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 can the Symbolic parameter be expanded

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
MohamedKhan

New User


Joined: 05 Apr 2007
Posts: 1
Location: India - Chennai

PostPosted: Fri Apr 27, 2007 9:51 am    Post subject: how can the Symbolic parameter be expanded
Reply with quote

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

ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Fri Apr 27, 2007 12:02 pm    Post subject:
Reply with quote

You can't do that using pure JCL. Use some utilities (like SORT) or programming language (like COBOL, REXX etc.).

O.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
No new posts DDNAME parameter mistah kurtz JCL & VSAM 6 Mon Dec 19, 2016 4:41 pm
No new posts Execessive parameter issue Sumeendar JCL & VSAM 5 Mon Dec 19, 2016 4:35 pm
No new posts TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
No new posts How to display value of an exit param... lind sh CICS 2 Sun Oct 09, 2016 12:28 pm


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