Comments inline.
On May 7, 9:26 am, pompeyoc <cati...@express.insular.com.phwrote:
Hi,
I am a newbie when it comes to stored procs and i would like to learn
how to call a COBOL program from a stored procedure. The SP can either
be an DB2 SQL SP or an external COBOL/DB2 SP. I can use either
depending on which is more efficient.
One of the older posts ("Calling a COBOL Subroutine from COBOL/DB2
Stored Procedure" Dec 2005) suggested this is possible but I couldn't
follow the explanation and there wasn't any examples. The post also
mentioned that using an ordinary COBOL call is less resource expensive
than using an SP call so I'd like to explore this further.
I have no experience with Cobol SP's on Unix-platforms, but you can
find additional info here:
http://publib.boulder.ibm.com/infoce...d/r0007176.htm
>
Also, pardon my ignorance, but could you tell me what the ff acronyms
are:
DSNALI
DSNELI
WLM
You seem to confuse Unix and mainframe (OS390 / zOS) terms.
WLM is the acronym for WorkLoadManager, the other 2 terms are names
for include-members for compiling/linking application programs using
DB2 on mainframe (for different environments: DSNALI is for the
CallAttachFacility, DSNELI for TSO; there are more of those, like
DSNCLI for CICS).
>
We are on AIX 5.2 (I think) using DB2 UDB ver 7.2 and MF COBOL 4.1.
Time for a migration, 'cause DB2 7 is out-of-support quite some time.
Note the link given above is for version 8.
Thanks in advance.
Your welcome.
>
Pompeyo C
--
Jeroen