View previous topic :: View next topic
|
Author |
Message |
anish.ibm
New User
Joined: 28 Jun 2007 Posts: 23 Location: Bangalore
|
|
|
|
Hi All ,
How to insert the Current date - 1 day into a dataset using Date features in DFSORT. Using DATE we can insert current date , but how to insert the current date - 1 Day .
Thanks
Anish. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
It's not clear exactly what you want to do. Do you want to insert date-1 in every record or in one record or what? What format do you want for the inserted date-1?
At any rate, DFSORT can insert date-1 day constants in various forms with the BUILD operand. For example:
Code: |
...
//SORTIN DD *
RECORD
//SYSIN DD *
OPTION COPY
INREC BUILD=(DATE1-1)
/*
|
Will insert a date-1 day constant in the form C'yyyymmdd'. For complete information on DFSORT's date-n and date+n constants, see:
Use [URL] BBCode for External Links
If you want more specific help, explain what you want to do in more detail with an example, if appropriate. |
|
Back to top |
|
|
anish.ibm
New User
Joined: 28 Jun 2007 Posts: 23 Location: Bangalore
|
|
|
|
Hi Frank,
Iam able to execute the below card
SORT FIELDS=COPY
OUTREC BUILD=(DATE1(.))
But unable to execute this
SORT FIELDS=COPY
OUTREC BUILD=(DATE1(.)-1) .... Getting Syntax Error
My requirement is ..single record should be replaced with Current date - 1 day.
Thanks
Anish. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
OUTREC BUILD=(DATE1(.)-1) .... Getting Syntax Error |
Please post the //SYSOUT messages you received. |
|
Back to top |
|
|
anish.ibm
New User
Joined: 28 Jun 2007 Posts: 23 Location: Bangalore
|
|
|
|
Hi Frank,
Please find the Sysout for the Syntax error below
Code: |
SYSIN :
SORT FIELDS=COPY
OUTREC BUILD=(DATE1(.)-1)
*
WER268A OUTREC STATEMENT : SYNTAX ERROR
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
|
Thanks
Anish. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
The statement I posted using DATE1-1 works fine with DFSORT. But the WER messages indicate you're using Syncsort, not DFSORT. |
|
Back to top |
|
|
anish.ibm
New User
Joined: 28 Jun 2007 Posts: 23 Location: Bangalore
|
|
|
|
Hi Frank,
I tried all the possiblities using ICETOOL,ICEMAN,SORT , but still iam getting the same error message. SYNCSORT FOR Z/OS 1.2.2.3R and SYNCTOOL RELEASE 1.5.2 was installed in my Shop. Is it possible to get the result what i need throught this product.
Thanks
Anish. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Anish,
I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort. |
|
Back to top |
|
|
anish.ibm
New User
Joined: 28 Jun 2007 Posts: 23 Location: Bangalore
|
|
|
|
HI All,
Can any epert in SYNCSORT explain me how to get the CURRENT DATE - 1 DAY . SYNCSORT allows for CURRENT DATE but not for PAST or FUTURE DATEs.
Thanks,
Anish. |
|
Back to top |
|
|
krisprems
Active Member
Joined: 27 Nov 2006 Posts: 649 Location: India
|
|
|
|
anish.ibm
Quote: |
SYNCSORT FOR Z/OS 1.2.2.3R and SYNCTOOL RELEASE 1.5.2 was installed in my Shop. Is it possible to get the result what i need throught this product |
Its not possible with this |
|
Back to top |
|
|
|