How to use PARM in DB2 RUN JCL

chkiran2 · New User Joined: 24 Jun 2004 Posts: 24 Location: Gurgoan

Hi
How to code the PARM parameter in a JCL to pass data to program which executes a DB2 program. I can do this using instream data. I want to know how to use PARM.

Thanks

superk · Posted: Sun Sep 05, 2004 7:56 am

I can find no evidence that it is possible to run a DB2 program directly without first starting the TSO program.

Perhaps you'd care to share why you believe that what you are asking for is possible?

anuradha · Posted: Tue Oct 12, 2004 6:53 pm

Hi Kiran,

To pass PARM parameter to JCL which executes DB2 program, In our shop we have one utility program which takes a parm passed to it and create a one record file that can be used as a SYSIN.

We execute that program three times:

1.first time we pass the actual DB2 program name as a PARM
2.Secondly we pass the actual PARM to be passed
3.Thidly we pass the PARM as "end"

And finally we will concatenate all the Above SYSUT2 steps (watever it may be) and execute IKJEFT01.

Hope this helps.

If someone has more effective solution they can provide here ,so that it may help all of us.

Thanks,
Anu