How do I call a COBOL program from a stored procedure?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pompeyoc - 07 May 2007 08:26 GMT

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.

Also, pardon my ignorance, but could you tell me what the ff acronyms
are:
DSNALI
DSNELI
WLM

We are on AIX 5.2 (I think) using DB2 UDB ver 7.2 and MF COBOL 4.1.

Thanks in advance.

Pompeyo C

Reply to this Message

Jeroen van den Broek - 07 May 2007 13:17 GMT

Comments inline.

> Hi,
>
[quoted text clipped - 8 lines]
> 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/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/ad/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

Reply to this Message

Jeroen van den Broek - 07 May 2007 13:32 GMT

On May 7, 2:17 pm, Jeroen van den Broek
<nlt...@baasbovenbaas.demon.nl> wrote:
<..>

> I have no experience with Cobol SP's on Unix-platforms, but you can
> find additional info here:http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/c...

Sorry, this link is pointing to IBM Cobol info, please use following
links instead.

Building UNIX Micro Focus COBOL applications:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/ad/r0007151.htm

Building UNIX Micro Focus COBOL routines:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/ad/r0007152.htm

Configuring the Micro Focus COBOL Compiler on AIX:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/ad/r0007164.htm

AIX Micro Focus COBOL application compile and link options:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/ad/r0007177.htm

AIX Micro Focus COBOL routine compile and link options:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/ad/r0007179.htm

HTH

--
Jeroen

Reply to this Message