|
View previous topic :: View next topic
|
| Author |
Message |
hiravibk
Warnings : 1
Active User
Joined: 14 Dec 2008
Posts: 107
Location: India
|
|
|
|
Hi All,
I have requirement to select only yesterdays records from a PS using a sort..I know similar process can be done for todays date using the below code
| Code: |
//SORTOUT DD SYSOUT=*
//SYSIN DD *
OPTION COPY
INREC OVERLAY=(81:7,4,1,2,4,2)
OUTFIL OMIT=(81,8,CH,EQ,DATE1),
BUILD=(1,80)
/* |
But, how can i do it yesterdays date. Please explain me how to do it.
Thank you,
Ravi |
|
| Back to top |
|
 |
sril.krishy
Active User
Joined: 30 Jul 2005
Posts: 183
Location: hyderabad
|
|
|
|
hiravibk,
Try this.
| Code: |
//SORTOUT DD SYSOUT=*
//SYSIN DD *
OPTION COPY
INREC OVERLAY=(81:7,4,1,2,4,2)
OUTFIL OMIT=(81,8,CH,EQ,&DATE1-1),
BUILD=(1,80)
/*
|
Thanks
Krishy |
|
| Back to top |
|
|
hiravibk
Warnings : 1
Active User
Joined: 14 Dec 2008
Posts: 107
Location: India
|
|
|
|
Hi Krishy,
your code worked fine.Thank you so much. |
|
| Back to top |
|
|
|
|
