|
View previous topic :: View next topic
|
| Author |
Message |
muralikrishnan_new
New User
Joined: 02 Jun 2013
Posts: 15
Location: India
|
|
|
|
I am trying to subtract 1 year from current date. I used the below options but I am getting errors,
| Code: |
SYSIN :
INREC FIELDS=(1,10,11:&DATE1P)
SORT FIELDS=COPY
OUTREC FIELDS=(1,10,DATEADD=(11,5,DTNSP=(YMD),-1,YEAR))
*
WER271A OUTREC STATEMENT : NUMERIC FIELD ERROR
|
| Code: |
SYSIN :
INREC FIELDS=(1,10,11:DATE1)
SORT FIELDS=COPY
OUTREC FIELDS=(1,10,SUBYEARS=(11,8,DT=(YMD),-1,YEAR))
*
WER268A OUTREC STATEMENT : SYNTAX ERROR
|
Could you please help me on to resolve this.
Thanks & Regards,
Muralikrishnan R[ |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
|
|
|
|
| Does the SYNCSORT manual tell you that you can subtract a year from a date? If so, use what the manual recommends. If you cannot find it in the manual, contact the vendor to determine whether or not what you want to do is even possible, and if so how to do it. If your site is licensed for the product, you have access to the documentation and vendor support. |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3109
Location: NYC,USA
|
|
|
|
Please try and check if sync sort supports.
| Code: |
//SYSOUT DD SYSOUT=*
//SORTIN DD *
20160701
//SORTOUT DD SYSOUT=*
//SYSIN DD *
OPTION COPY
OUTREC BUILD=(1,8,Y4T,SUBYEARS,+1,TOGREG=Y4T(/),2X,
1,8,Y4T,SUBYEARS,+1,TOGREG=Y4T(-)) |
|
|
| Back to top |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
