View previous topic :: View next topic
|
Author |
Message |
sqlmainframe
New User
Joined: 01 Dec 2006 Posts: 2 Location: USA
|
|
|
|
In one of my projects I am needing to read the contents of a dataset as the parameter that I am passing to the proc. Is there a way to do this?
Below is an example of a piece of the JCL and where I need to be able to read the contents of the dataset:
//SQLLDR EXEC ORALDRXX,REGION=0M,USERID='READ CONTENTS',
// INDEX=IDOX00P.PO |
|
Back to top |
|
|
DavidatK
Active Member
Joined: 22 Nov 2005 Posts: 700 Location: Troy, Michigan USA
|
|
|
|
sqlmainframe,
I think we are unclear on what you are trying to accomplish here.
Can you please re-state your question in more detail?
Thanks,
Dave |
|
Back to top |
|
|
sqlmainframe
New User
Joined: 01 Dec 2006 Posts: 2 Location: USA
|
|
|
|
I need to override a symbolic parameter.
Below is the portion of the proc that contains the symbolic parameter I need to override. It is in bold.
//ORALDR EXEC PGM=SQLLDR,REGION=4M,
// PARM=('CONTROL=/DD/&INDD USERID=&USERID',
// 'LOG=/DD/&LOGDD DIRECT=&D')
The data that needs to be read into the proc is contained within a PDS on the mainframe. I need the PROC to accept the contents of the dataset instead of hardcoding the data into the JCL. Is there a way within JCL to do this?
Below is the portion of the JCL:
//SQLLDR EXEC ORALDRXX,REGION=0M,USERID='USERID/PASSWORD',
// INDEX=IDOX00P.PO
Hopefully this clarify the question. |
|
Back to top |
|
|
|