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
 

 

Syntax needed to pass date thru DSN in Outfil file

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

New User


Joined: 05 Sep 2006
Posts: 34

PostPosted: Fri Dec 15, 2006 5:54 pm    Post subject: Syntax needed to pass date thru DSN in Outfil file
Reply with quote

Hi All

I have an input file having date field AT 15th position in I/P file
The code is as below:

Code:

//SORTIN   DD  DSN=i/p file which has date field at 15th position,
//             DISP=SHR                             
//SORTOF01 DD  DSN=o/p file 1 ,           
//             DISP=OLD           
//SORTOF02 DD  DSN=o/p file 2,   
//             DISP=OLD           
//SYSIN    DD  *                                   
   SORT FIELDS=(1,2,BI,A,3,2,BI,A,5,2,BI,A,7,4,BI,A,
                11,2,BI,A,13,2,BI,A,15,10,CH,A)     
  OUTFIL FILES=01,INCLUDE=(15,10,CH,LE,&DATE1(-)+1)
  OUTFIL FILES=02,INCLUDE=(15,10,CH,GT,&DATE1(-)+1)
/*


As of now this syntax works fine .

My requirement is that "Instead of &DATE1 ... i want the DATE to be passed thru a DSN which will have date as '12082006')

Shrinivas
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: Fri Dec 15, 2006 8:53 pm    Post subject:
Reply with quote

You can put the date in a DFSORT Symbols data set:

Code:

//SYMNAMES DD DSN=ds1,...  (FB/80)
...
//SYSIN DD *
  OUTFIL FILES=01,INCLUDE=(15,10,CH,LE,Mydate)
  OUTFIL FILES=02,INCLUDE=(15,10,CH,GT,Mydate)


where ds1 has:

Mydate,'12082006'
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 Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts JES2 JEC: Use UNIX Pipes to Pass Data... Virendra Shambharkar JCL & VSAM 21 Tue Dec 20, 2016 6:55 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm


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