Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Validate the Date girishb2 DFSORT/ICETOOL 9 Tue Sep 19, 2017 1:12 am
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Julian Date to CICS ABSTTIME blayek CICS 3 Wed Aug 30, 2017 11:15 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us