MVSFORUMS.com

ssd · Beginner Joined: 24 Mar 2006 Posts: 25 Topics: 10

I am looking for a sample piece of code that would illustrate calling of COBOL DB2 program from an rexx exec. Can anyone help ?

acevedo · Posted: Mon Aug 20, 2007 6:37 am Post subject:

without db2

ssd · Beginner Joined: 24 Mar 2006 Posts: 25 Topics: 10

Acevedo,
I tried as you had suggested. The program executed Successfully
But a system dump was produced at the end of execution and my TSO session automatically logged off ? What is wrong here ?

kolusu · Posted: Mon Aug 20, 2007 11:18 am Post subject:

ssd,

Did you change the bold item values in the code? SSID should be your DB2 region ID. parameters are your plan name and any other parm you need to pass to the program

ssd · Beginner Joined: 24 Mar 2006 Posts: 25 Topics: 10

Kolusu,
As mentioned in the previous post , the program executed successfully (and produced the desired output), meaning I had given the correct parameters and the subsystem ID.

I was partially able to find out the reason for the dump and the subsequent logoff which is explained below:

In my DB2 program I am creting a dynamic file.
Whenever I run the rexx exec without deleting the dynamic file created on the previous instance the dump and the logoff happens.

But my opinion is that this shouldnt happen unless otherwise the error is serious enough to terminate a mainframe session.

Any explanation as to why this happened ?

Thanks
SSD