MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Usage of VARCHAR in Stored Procedure

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
SureshKumar
Intermediate


Joined: 23 Jan 2003
Posts: 211
Topics: 21

PostPosted: Wed May 12, 2004 8:19 am    Post subject: Usage of VARCHAR in Stored Procedure Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group