|
View previous topic :: View next topic
|
| Author |
Message |
ykishore
New User
Joined: 12 Aug 2005
Posts: 53
Location: USA
|
|
|
|
Hi
Here is my requirement!!
i've a file which has DATE column.but it doesnt have centuary part!!! here i want to sort the date on ascending order!!!!
for eg:
Input:
---------
0512
0510
9501
9201
9911
if i sort the above date col on ascending order, i do get the output as below!!!
output:
----------------
0501
0510
0512
9201
9501
9911
but when we consider year wise result may be wrong...so i want the output as below.
output:
--------
9201
9501
9911
0501
0510
0512
so can you guys provide me the JCL for the same!!! i know that we can do this by adding centuary part to the year.but is there anyother ways do it!!!! |
|
| Back to top |
|
 |
radhakrishnan82
Active User
Joined: 31 Mar 2005
Posts: 435
Location: chennai, India
|
|
|
|
kishore,
Use this condition in sort
| Code: |
| SORT FIELDS=(1,6,Y2T,A),CENTWIN=1950 |
hope this helps. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
| Back to top |
|
|
|
|
