By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,077 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,077 IT Pros & Developers. It's quick & easy.

External Stored Procedures Limitations?

P: n/a
Hi. I was wondering if anyone out here knows if there is a limit to
the size of an external stored procedure? I am currently using VB
programs in Windows to call small COBOL stored procs residing in AIX
without any problems. This time, however, I am planning to have
another VB program call a COBOL stored proc that, in turn, calls other
COBOL programs via ordinary COBOL CALLs.

Any ideas?
Jan 8 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
pompeyoc wrote:
Hi. I was wondering if anyone out here knows if there is a limit to
the size of an external stored procedure? I am currently using VB
programs in Windows to call small COBOL stored procs residing in AIX
without any problems. This time, however, I am planning to have
another VB program call a COBOL stored proc that, in turn, calls other
COBOL programs via ordinary COBOL CALLs.
Once you are in the external world it's up to the OS.
Only when you do the CALL via SQL does and can DB2 count.
The current limit for SQL CALLs is 64 (entirely arbitrary).

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Jan 8 '08 #2

P: n/a
On Jan 8, 7:31 pm, Serge Rielau <srie...@ca.ibm.comwrote:
pompeyoc wrote:
Hi. I was wondering if anyone out here knows if there is a limit to
the size of an external stored procedure? I am currently using VB
programs in Windows to call small COBOL stored procs residing in AIX
without any problems. This time, however, I am planning to have
another VB program call a COBOL stored proc that, in turn, calls other
COBOL programs via ordinary COBOL CALLs.

Once you are in the external world it's up to the OS.
Only when you do the CALL via SQL does and can DB2 count.
The current limit for SQL CALLs is 64 (entirely arbitrary).

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Thanks for the reply, Serge. Which OS are you referring to? Windows or
AIX?
Jan 9 '08 #3

P: n/a
pompeyoc wrote:
On Jan 8, 7:31 pm, Serge Rielau <srie...@ca.ibm.comwrote:
>pompeyoc wrote:
>>Hi. I was wondering if anyone out here knows if there is a limit to
the size of an external stored procedure? I am currently using VB
programs in Windows to call small COBOL stored procs residing in AIX
without any problems. This time, however, I am planning to have
another VB program call a COBOL stored proc that, in turn, calls other
COBOL programs via ordinary COBOL CALLs.
Once you are in the external world it's up to the OS.
Only when you do the CALL via SQL does and can DB2 count.
The current limit for SQL CALLs is 64 (entirely arbitrary).
Thanks for the reply, Serge. Which OS are you referring to? Windows or
AIX?
Whichever your OS is... DB2 loads the library and invokes it - hands of.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Jan 9 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.