SureshKumar
Intermediate
Joined: 23 Jan 2003
Posts: 211
Topics: 21
|
 Posted: Wed May 12, 2004 8:19 am Post subject: Usage of VARCHAR in Stored Procedure |
 |
|
HI,
I would like to know if using VARCHAR in a Stored Procedure OUT parameter will be efficient ? I have a requirement to return a large block of data to the client thru a VARCHAR field, maybe multiple VARCHAR fields. The VARCHAR OUT field will be about 24,000 bytes. The VARCHAR field will contain an array of elements. Its possible that the return could be empty or have partial information.
My question is will DB2 Connect recoganize the VARCHAR and its length and transmit only the available data or the entire block ?
Should I consider using Null indicators to force DB2 to recoganize that data is not available ?
have any of you had exposure of converting a CICS transaction to be routed thru DB2 connect ?
I am working on a requirement to eliminate CICS calls(for $$ reasons) and have the same funcationality thru DB2 stored procedures. Since the CICS Commarea is restricted by the 24K limit, the client in this case makes multiple calls to retreive all the information. We would like to exploit the storage limitations on DB2 Connect (about 5.4mb) to retreive all the information in one call. for the time being CTT's and Result Set's are ruled out. I am considering CTT but the DBA's have concerns, the bussiness model is not favourable to use result Set. Thanks |
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
