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 give Symbolic overrides in INCLUDE statement of SYSIN

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Tamanna

New User


Joined: 07 Oct 2006
Posts: 6
Location: Chennai

PostPosted: Wed Apr 25, 2007 3:05 pm    Post subject: How to give Symbolic overrides in INCLUDE statement of SYSIN
Reply with quote

Can any one please let me know how to give a Symbolic overrides within SYSIN card of SORT statement in JCL .

Example:

Code:

//SYSIN    DD *                         
  SORT FIELDS=COPY
  INCLUDE COND=(20,01,CH,EQ,C'R',AND,       
            90,07,CH,GE,C'2070416',AND,
            90,07,CH,LE,C'2070422')     


Can the date variables '2070416' and '2070422' be overriden ?
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Wed Apr 25, 2007 3:25 pm    Post subject:
Reply with quote

Input can not be overriden directly but a sysin dataset can be created dynamically.
Back to top
View user's profile Send private message
Tamanna

New User


Joined: 07 Oct 2006
Posts: 6
Location: Chennai

PostPosted: Wed Apr 25, 2007 3:34 pm    Post subject: Re: How to give Symbolic overrides in INCLUDE statement of S
Reply with quote

Can you please let me know the procedure to create Dynamic Sysin card so that manual updation of data can be avoided within the INCLUDE statement
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Apr 25, 2007 8:19 pm    Post subject:
Reply with quote

You can use DFSORT Symbols for fields or constants in DFSORT and ICETOOL statements. For example, you could use:

Code:

...
//SYMNAMES DD *
MYDATE1,'2070416'
MYDATE2,'2070422'
/*
//SYSIN DD *
  SORT FIELDS=COPY
  INCLUDE COND=(20,01,CH,EQ,C'R',AND,       
            90,07,CH,GE,MYDATE1,AND,
            90,07,CH,LE,MYDATE2)     
/*


You can then override MYDATE1 and MYDATE2 with any dates you supply in SYMNAMES. For example:

Code:

//SYMNAMES DD *
MYDATE1,'2070501'
MYDATE2,'2070512'
/*


SYMNAMES can also point to a sequential data set or pds member as long as it has RECFM=FB and LRECL=80.

For more information on DFSORT symbols, see:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/7.0?DT=20060615185603

If that's not what you want to do, then you need to explain in more detail what it is you want to do.
Back to top
View user's profile Send private message
Tamanna

New User


Joined: 07 Oct 2006
Posts: 6
Location: Chennai

PostPosted: Thu Apr 26, 2007 1:54 pm    Post subject: Re: How to give Symbolic overrides in INCLUDE statement of S
Reply with quote

Thanks frank.

The above code is working fine. But please find a small change to it.

Code:

//SYMNAMES DD *                             
MYDATE1,C'2070501'                         
MYDATE2,C'2070502'                     
/*                                         
//SYSIN    DD *                             
  SORT FIELDS=COPY                           
  INCLUDE COND=(20,01,CH,EQ,C'R',AND,       
                90,07,CH,GE,MYDATE1,AND,     
                90,07,CH,LE,MYDATE2)         
/*
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Apr 26, 2007 8:59 pm    Post subject:
Reply with quote

A small, unnessary change. DFSORT will treat:

MYDATE1,'2070501'

the same as:

MYDATE1,C'2070501'

You can code the C if you like but you don't need it.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Include/omit with "ALL" pa... mgl DFSORT/ICETOOL 6 Wed Jun 14, 2017 2:31 pm
No new posts LISTCAT on a dataset with symbolic pa... shreya19 JCL & VSAM 5 Fri Apr 07, 2017 5:43 pm
No new posts scheduling between OPC and TWS give u... nsbl IBM Tools 4 Sun Mar 12, 2017 5:35 pm
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
No new posts VALIDATE NULL VALUE IN DB2 CASE STATE... useit DB2 5 Thu Feb 09, 2017 4:34 pm


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