Is it possible to eliminate DUPLICATES and at the same time , again use SORT FIELDS in the sort card to Sort a particular field in the ascending order ? Giving the SORT FIELDS twice gives the error :
WER269A SORT STATEMENT : DUPLICATE STATEMENT FOUND
I am trying to select Unique records using SORT FIELDS on the column -
and then when I write my report I am trying to sort the output records based on the STATE by using
How else can I get my output sorted Statewise without using SORT FIELDS again.
The following is my SORT CARD :
HEADER2=(30:'J A Y S R E P O R T O N IYUIOS 5',/,
35:'LAST PURCHASES MADE IN 2003',//,
As the message indicates, Syncsort does not support the usage of more than one SORT statement. Also you cannot expect it to work the way you're expecting.
The JOIN operation sorts your input files on the key fields by default unless you specify the 'SORTED' option which implies that the files are presorted. You can specify only a single SORT statement which takes the JOINed records as input. If you describe what exactly you are trying to do, somebody here might be able to help.