View previous topic :: View next topic
|
Author |
Message |
MohamedKhan
New User
Joined: 05 Apr 2007 Posts: 1 Location: India - Chennai
|
|
|
|
Hi All,
I have my JCL as below.
Code: |
//*
//DBNAME SET DBNAME='SR00001D'
//*
//SQLBATCH EXEC PGM=IKJEFT01
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSN)
RUN PROGRAM(DSNTEP2) LIBRARY ('SYS3.RUNLIB.LOAD')
END
/*
//SYSIN DD *
SELECT * FROM
SYSIBM.SYSDATABASE
WHERE
NAME=&DBNAME
/*
|
I want to know how can the Symbolic parameter be expanded (Like DBNAME replaced by SR00001D) in the above JCL.
As of now when i run this JCL the Name is being taken as DBNAME, but i want it to be SR00001D (as set in SET parameter).
Thanks
Mohamed Sikander |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
You can't do that using pure JCL. Use some utilities (like SORT) or programming language (like COBOL, REXX etc.).
O. |
|
Back to top |
|
|
|