Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to use PARM in DB2 RUN JCL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
chkiran2

New User


Joined: 24 Jun 2004
Posts: 24
Location: Gurgoan

PostPosted: Thu Sep 02, 2004 9:50 am    Post subject: How to use PARM in DB2 RUN JCL
Reply with quote

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
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Sun Sep 05, 2004 7:56 am    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
anuradha

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

PostPosted: Tue Oct 12, 2004 6:53 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Using 'parm' to vary SORTOUT record v... Sysaron DFSORT/ICETOOL 13 Wed Sep 07, 2016 9:24 pm
No new posts Copy a particular column based on PAR... brindhamohan DFSORT/ICETOOL 5 Wed May 11, 2016 8:49 am
No new posts Use of Parm in SORT Ambili S DFSORT/ICETOOL 2 Mon May 09, 2016 9:16 pm
No new posts symbolic parm - allocate dsn krrp JCL & VSAM 11 Sat Oct 31, 2015 8:27 pm
No new posts EXEC SORT,REGION=0M,PARM=ELAP venugopal.mft DFSORT/ICETOOL 4 Wed May 20, 2015 12:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us