Maximum length of Parm returned from Stored Procs

catchyblues · New User Joined: 28 Dec 2005 Posts: 24

Hi

Can anyone please tell me what can be the maximum length of parm
which can be returned from a Cobol DB2 stored proc....

and also can you please let me know where can i find this information ( if you can provide me the link for tht, it will be gr8.....)

Thanks
CB

William Thompson · Posted: Mon Mar 19, 2007 10:59 pm

I didn't see it here but you might....
But then again, it might just be a function of COBOL

catchyblues · New User Joined: 28 Dec 2005 Posts: 24

thanks for the help.... I could find the information in this link

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/EZ325801/2.3.1.2?DT=19980402151428#HDRCH02PRM

William Thompson · Posted: Tue Mar 20, 2007 5:59 pm

Good, now would you please share with us the answer to the question "what can be the maximum length of parm which can be returned from a Cobol DB2 stored proc"?

catchyblues · New User Joined: 28 Dec 2005 Posts: 24

32765 bytes... if we declare the parm as a varchar