MVSFORUMS.com

schintala · Posted: Tue May 24, 2005 3:22 pm Post subject: Stored Procedure

Is there any limitation in having IN & OUT parameters in a stored procedure. We got a situatuion to handle more than 100 variables to be received from SP. I searched the google could not found the specific to this one. I wonder if we can have this many or to have in different SPs. Any reply on this would be a great help.

kolusu · Posted: Tue May 24, 2005 7:26 pm Post subject:

schintala,

Prior to DB2 version 6 Stored procedures could only allow up to 254 bytes. It does not matter how many variables you define, the total size cannot be more than 254 for Db2 versions 4 and 5

From DB2 version 6, the limit was raised to 32,767 bytes. so you can define 32,766 variables with a size of 1 byte each.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu