JayC
New User
Joined: 27 Sep 2008
Posts: 70
|
|
|
|
Hi ...
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 :
| Code: |
WER269A SORT STATEMENT : DUPLICATE STATEMENT FOUND
|
I am trying to select Unique records using SORT FIELDS on the column -
SORT FIELDS=(15,10,CH,A)
and then when I write my report I am trying to sort the output records based on the STATE by using
SORT FIELDS=(68,2,CH,A)
How else can I get my output sorted Statewise without using SORT FIELDS again.
The following is my SORT CARD :
| Code: |
JOINKEYS FILE=F1,FIELDS=(15,10,A)
SORT FIELDS=(15,10,CH,A),EQUALS
SUM FIELDS=NONE
JOINKEYS FILE=F2,FIELDS=(01,10,A)
REFORMAT FIELDS=(F2:1,67,F1:25,6)
SORT FIELDS=(68,2,CH,A),EQUALS
OUTFIL REMOVECC,
HEADER2=(30:'J A Y S R E P O R T O N IYUIOS 5',/,
35:'LAST PURCHASES MADE IN 2003',//,
02:'NAME',
20:'STREET ADDRESS',
52:'CITY',
68:'STATE',
75:'DATE',/),
OUTREC=(02:11,15,
20:31,20,
52:51,15,
68:68,2,
73:70,2,C'/',72,2,C'/',68,2)
|
|
|
