View previous topic :: View next topic |
Author |
Message |
dmk01 Beginner
Joined: 09 Oct 2007 Posts: 2 Topics: 3
|
Posted: Thu May 15, 2008 12:01 pm Post subject: Convert 'YYYYMMDD' to Current Date |
|
|
Hi,
I have a file which has a string 'YYYYMMDD'. I want to convert that string with Current Date (Ex:20080515). Is it possible with SORT Utility?
Thanks,
DMK |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Thu May 15, 2008 12:24 pm Post subject: |
|
|
dmk01,
The following DFSORT jcl will give you the desired results
Code: |
//STEP0100 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD *
YYYYMMDD
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
OUTREC OVERLAY=(1:DATE1)
/* |
Hope this helps...
Cheers _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
 |
|
|