Hi,

I've been reading and searching for what I thought should be simple information. Hoping someone can answer or point me to the doc's on this.

zOS, v9 DB2. We want to invoke cobol code(batch/WLM) via a stored procedure. We know it can be done but are trying to figure out;

1) Maximum number of parameters that a stored procedure can accept?
2) Maximum number of parameters that can be used to invoke the cobol code?
3) Is there maximum size limit for the total parameters (total KB)
4) Is there a maximum size limit for the total stored procedure code size?


THANKS!!

Perhaps this Redbook will help DB2 9 for Z/os Stored Procedures: Thru the Call and beyond

Nothing stood out in this doc for what we were looking for. We just have not found this information documented. Asking our IBM contacts has not been helpful, too many experts with no answers

Did you try the manual?

IBM Information Management Software for z/OS Solutions Information Center

Thank and one of the better catches. However, still misses the target of stored procedure, cobol .....