IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SYNCSORT needed to get current plus 1 date in SORTOUT file


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
shrinivas_3
Warnings : 1

New User


Joined: 05 Sep 2006
Posts: 34

PostPosted: Fri Dec 22, 2006 10:47 am
Reply with quote

Hi All

I need JCL syntax to get current date + 1 in sort out file .
My sort-in file is 80 lrecl FB having only current date.
Now I want the sortout file to have current +1 date .

Solution could be provided with any type of date format .

Thanks
Shrinivas D
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


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

PostPosted: Fri Dec 22, 2006 9:10 pm
Reply with quote

Here's a DFSORT job that will do what you asked for:

Code:

//S1 EXEC PGM=ICEMAN           
//SYSOUT DD SYSOUT=*           
//SORTIN DD *                 
20061222                       
//SORTOUT DD SYSOUT=*         
//SYSIN DD *                   
  OPTION COPY                 
  INREC OVERLAY=(1:DATE1+1)   
/*                             


Today, SORTOUT would have:

20061223

You'll need z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006) in order to use DFSORT's DATE1+1 function. If you don't have April, 2006 PTF, ask your System Programmer to install it (it's free). For complete details on all of the new DFSORT and ICETOOL functions available with the April, 2006 PTF, see:

Use [URL] BBCode for External Links
Back to top
View user's profile Send private message
Rajen

New User


Joined: 05 May 2005
Posts: 61

PostPosted: Thu Dec 28, 2006 8:24 pm
Reply with quote

Hi Frank,
i tried your jcl but it abended with RC=16 and gave below mentioned error message.

SYNCSORT FOR Z/OS 1.2.0.1R U.S. PATENTS: 4210961, 5117495
PRODUCT LICENSED FOR CPU SERIAL NUMBER 6522F, MODEL 2064 106
Back to top
View user's profile Send private message
William Thompson

Global Moderator


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

PostPosted: Thu Dec 28, 2006 8:36 pm
Reply with quote

Never mind...Just checked the programmers guide and no mention of intelligent date functions.....
BTW, If Frank ever says to check for a PTF, it's a (almost) sure bet that Syncsort won't be able to do it (yet?)..... icon_cry.gif
Back to top
View user's profile Send private message
William Thompson

Global Moderator


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

PostPosted: Thu Dec 28, 2006 8:41 pm
Reply with quote

I think the Syncsort messages (including errors) have a "WER" prefix - usually these can help identify what caused the RC=16....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Binary File format getting change whi... All Other Mainframe Topics 5
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts WER247A SORTOUT HAS INCOMPATIBLE LRECL SYNCSORT 7
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
Search our Forums:

Back to Top