You'll need to PARSE the fields in INREC, then make a temporary extension to the record. Heed Robert's point about sorting in a logical order (year, month, day).
In OUTREC, use BUILD to return the record to its original size.
Thanks but what are you saying when you say "a temporary extension to ...
Search found 3 matches
- Thu Sep 10, 2015 11:48 am
- Forum: SyncSort, SyncTool, SyncGener.
- Topic: SORT records on date.
- Replies: 7
- Views: 6297
- Thu Sep 10, 2015 11:47 am
- Forum: SyncSort, SyncTool, SyncGener.
- Topic: SORT records on date.
- Replies: 7
- Views: 6297
Re: SORT records on date.
Dates are in DD.MM.YYYY format.Robert Sample wrote:What format are the dates in? You cannot put together a SORT statement without knowing that. Whatever the format, you'll want to sort by year, month, day to get the data in ascending date sequence.
- Wed Sep 09, 2015 9:40 pm
- Forum: SyncSort, SyncTool, SyncGener.
- Topic: SORT records on date.
- Replies: 7
- Views: 6297
SORT records on date.
Hi,
I need to sort the records in a dataset based on date in ascending order. If there are three dates namely 31.1.1998, 2.12.1997,3.6.2014 then output should have 2.12.1997,31.1.1998,3.6.2014
I have used the sort card:
SORT FIELDS =(60,10,UFF,A)
But the records are not getting sorted properly ...
I need to sort the records in a dataset based on date in ascending order. If there are three dates namely 31.1.1998, 2.12.1997,3.6.2014 then output should have 2.12.1997,31.1.1998,3.6.2014
I have used the sort card:
SORT FIELDS =(60,10,UFF,A)
But the records are not getting sorted properly ...