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?
3  2063 
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
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?
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Bã§TãRÐ |
last post by:
I have been working on this particular project for a little over 2 weeks now. This product contains between 700-900 stored procedures to handle just about all you can imagine within the product. I...
|
by: aklikic |
last post by:
Hi,
I would like to create stored procedure that can call, for example dll
and pass String, and dll returns changed string back. How is this
possible? Can someone write me an example.
Thanks,...
|
by: Kent Lewandowski |
last post by:
hi all,
Recently I wrote some stored procedures using java jdbc code
(admittedly my first stab) and then tried to implement the same within
java packages (for code reuse). I encountered...
|
by: Tim Marshall |
last post by:
I was following the thread "Re: Access Treeview - Is it Safe Yet?" with
interest and on reading the post describing Lauren Quantrell's
SmartTree, I've run into something I don't understand: Stored...
|
by: JV |
last post by:
A ref cursor data type can obviously be returned as an output parameter of a
stored procedure, but can an ASP.NET application call an oracle proc that
uses a ref cursor as an input parameter? If...
|
by: Peter |
last post by:
I just bought VS.NET Standard 2005.
But there aren't any projects for Windows Services and I know that I cannot
develop VB.NET Stored Procedures (perhaps no projects for this too)
But can I get...
|
by: raindogs |
last post by:
I know you're not really supposed to do this, but I have a stored procedure that creates another database (using the tips in this thread: http://www.thescripts.com/forum/thread81377.html). It all...
|
by: anthonyroach |
last post by:
How would I execute two independent SQL statements in the same stored
procedure? I have a business process that requires a number of long-
running procedures to be executed. The procedures...
|
by: peter |
last post by:
I am trying to get a SQL stored procedure to use user maintained MQT
implicitly which raises questions on when they are used or not used.
In theory you would expect the stored procedure to pick up...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
