|
View previous topic :: View next topic
|
| Author |
Message |
Satyajit
New User
Joined: 25 Jan 2006
Posts: 27
|
|
|
|
I am trying to perform the following operation thru sort but its not working.what is the correct way to do the same?
| Code: |
SORT FIELDS=COPY
INREC FIELDS=(1:15,8,10:112,4)
INCLUDE COND=((15,8,CH,EQ,C'ZTE1CBR',AND,112,4,CH,NE,C'0057',)
,OR,(15,8,CH,EQ,C'ZTE1CBR',AND,112,4,CH,NE,C' ')
,OR,(15,8,CH,EQ,C'ZTE1065',AND,112,4,CH,NE,C'0052'))
|
If my input is for INCLUDE COND to be applied is
| Code: |
ZTE1CBR 0062
ZTE1CBR 0057
ZTE1CBR 0062
ZTE1CBR
ZTE1065 0052
ZTE1065 0057
ZTE1065 0052
|
My Output should be
| Code: |
ZTE1CBR 0062
ZTE1CBR 0062
ZTE1CBR
ZTE1065 0057
|
|
|
| Back to top |
|
 |
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
Well, the correct syntax would be:
| Code: |
SORT FIELDS=COPY
INCLUDE COND=((15,8,CH,EQ,C'ZTE1CBR',AND,112,4,CH,NE,C'0057'),OR,
(15,8,CH,EQ,C'ZTE1CBR',AND,112,4,CH,NE,C' '),OR,
(15,8,CH,EQ,C'ZTE1065',AND,112,4,CH,NE,C'0052'))
INREC FIELDS=(1:15,8,10:112,4)
|
But this does not give you the output you say you want from the input you show. The output for these control statements is:
| Code: |
ZTE1CBR 0062
ZTE1CBR 0057
ZTE1CBR 0062
ZTE1CBR
ZTE1065 0057
|
You need to work out the correct logic for whatever it is you're trying to do and use the correct syntax as well. |
|
| Back to top |
|
|
|
|
|
