|
View previous topic :: View next topic
|
| Author |
Message |
nivasaya
New User
Joined: 03 May 2007
Posts: 27
Location: India
|
|
|
|
Please let me know the Efficient SORT step for the requirement below
Sort TGM file
TGM-REC-TYPE EQUAL ‘5’ AND
TGM-ACC(1:5) NOT EQUAL ‘00005’
Thanks & regards,
Nivasaya |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
SORTIN -
RECFM=
LRECL=
Position and datatype of TGM-REC=
Position and datatype of TGM-ACC= |
|
| Back to top |
|
|
nivasaya
New User
Joined: 03 May 2007
Posts: 27
Location: India
|
|
|
|
Thanks Expat.
5 Similar SEQ files ( ORG - PS ) with REC FORMAT as FB
and i need to extract to 1 O/P file only for the conditions below
TGM-REC-TYPE EQUAL ‘5’ AND
TGM-ACC(1:5) NOT EQUAL ‘00005’
Thanks & Regards,
Nivasaya |
|
| Back to top |
|
|
nivasaya
New User
Joined: 03 May 2007
Posts: 27
Location: India
|
|
|
|
| Code: |
SORT FIELDS = COPY
INCLUDE COND=(1,1,CH,EQ,C’5’,
7,5,CH,NE,C’00005’)
|
Will these be fine |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| Will these be fine |
No, but these DFSORT control statements would:
| Code: |
SORT FIELDS=COPY
INCLUDE COND=(1,1,CH,EQ,C'5',AND,
7,5,CH,NE,C'00005')
|
|
|
| Back to top |
|
|
nivasaya
New User
Joined: 03 May 2007
Posts: 27
Location: India
|
|
|
|
Thanks Frank.
Yes i got the " AND " condition as well as SORT FIELDS=COPY
Thank you very much for your timely support
Thanks & Regards,
Nivasaya |
|
| Back to top |
|
|
|
|
