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
 

 

Getting Date -1 day using SYNCSORT

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

New User


Joined: 05 May 2005
Posts: 29

PostPosted: Thu Jun 19, 2008 2:21 am    Post subject: Getting Date -1 day using SYNCSORT
Reply with quote

I am using the sort reporting feature for creating one of the reports. The report has previous days date in the heading. Is there a way I can get it in my report heading using sort ?
Back to top
View user's profile Send private message

Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Thu Jun 19, 2008 9:07 pm    Post subject:
Reply with quote

If you want yesterday's date in the report heading, you can code an OUTFIL HEADER1 with &DATE-1. If this is not what you are looking for, please be more specific in your requirements.
Back to top
View user's profile Send private message
sudhakarraju

New User


Joined: 05 May 2005
Posts: 29

PostPosted: Fri Jun 20, 2008 1:02 am    Post subject: Getting the following error when using &DATE-1
Reply with quote

SYNCSORT FOR Z/OS 1.2.3.0R U.S. PATENTS: 4210961, 5117495 (C) 2005 SYNCSORT

PARMEXIT : VSCORE=1024K,VSCORET=8M
SYSIN :
SORT FIELDS=COPY
OUTFIL OUTREC=(1,80),HEADER2=(1:&DATE-1)
*
WER903I SYNCSORT 1.2.3.0 IS NOT LICENSED FOR SERIAL 29A21, TYPE 2097 713, LPAR
WER903I SYNCSORT WILL STOP WORKING IN 41 DAYS UNLESS A VALID KEY IS INSTALLED
WER161B ALTERNATE PARM USED
WER268A OUTFIL STATEMENT : SYNTAX ERROR
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Fri Jun 20, 2008 3:34 am    Post subject: Reply to: Getting Date -1 day using SYNCSORT
Reply with quote

sudha,

Quote:
OUTFIL OUTREC=(


In the sort cards i have seen/written OUTFIL is usually followed by FNAMES or BUILD. Just check the syntax of OUTFIL and code.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Fri Jun 20, 2008 10:26 pm    Post subject: Re: Getting the following error when using &DATE-1
Reply with quote

sudhakarraju wrote:
SYNCSORT FOR Z/OS 1.2.3.0R U.S. PATENTS: 4210961, 5117495 (C) 2005 SYNCSORT

PARMEXIT : VSCORE=1024K,VSCORET=8M
SYSIN :
SORT FIELDS=COPY
OUTFIL OUTREC=(1,80),HEADER2=(1:&DATE-1)
*
WER903I SYNCSORT 1.2.3.0 IS NOT LICENSED FOR SERIAL 29A21, TYPE 2097 713, LPAR
WER903I SYNCSORT WILL STOP WORKING IN 41 DAYS UNLESS A VALID KEY IS INSTALLED
WER161B ALTERNATE PARM USED
WER268A OUTFIL STATEMENT : SYNTAX ERROR

Support for the System Date with an Offset in OUTFIL processing was included in SyncSort for z/OS 1.3. You are running an earlier release of the product. That is why you got the syntax error.
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 How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm
No new posts LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm
No new posts SUBSTR for Date functions Shaheen Shaik DB2 4 Thu Apr 06, 2017 2:14 pm
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm


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