| 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: 12395 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 |
|
 |
|
|
|