joelacs1068
New User
Joined: 24 Aug 2006
Posts: 9
|
|
|
|
Hi,
Can you help me how to do this:
I have 1 file but I need to include only certain records based on the condition below using sort or Icetools utility How can I do that.
1-6 Action Code
7-12 - Customer Number
13-14 Division Code
15-15 Channel ID
16-18 Receiving Country Code
19-21 - Country Number
This is the condition
1. Action Code = blank, or
2. Action Code = (blank or WCTLN1), and CUSTNUM is not blank, and BMDIV = 13, 4S, 4Z, 44, 88, and CHANID = G, H, J, K, L, and RCTRYNUM = CTRYNUM , or
3. Action Code = blank, and CUSTNUM is blank, and BMDIV = 88, and RCTRYNUM = CTRYNUM |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
Joel,
| Quote: |
1. Action Code = blank, or
2. Action Code = (blank or WCTLN1), and CUSTNUM is not blank, and BMDIV = 13, 4S, 4Z, 44, 88, and CHANID = G, H, J, K, L, and RCTRYNUM = CTRYNUM , or
3. Action Code = blank, and CUSTNUM is blank, and BMDIV = 88, and RCTRYNUM = CTRYNUM |
These conditions don't make sense. Condition 1 will include all of the records with Action code = blank. So all of the records with Action code = blank will be included regardless of the other two conditions which also start with Action code = blank and add other conditions. The only other condition that adds anything is condition 2 for Action code = WCTLN1. I'd suggest reevaluating your conditions.
But for the sake of illustration, you could use DFSORT control statements like this for the stated conditions:
| Code: |
OPTION COPY
INCLUDE COND=(1,6,CH,EQ,C' ',OR,
((1,6,CH,EQ,C' ',OR,1,6,CH,EQ,C'WCTLN1'),AND,
7,6,CH,NE,C' ',AND,
13,2,SS,EQ,C'13,4S,4Z,44,88',AND,
15,1,SS,EQ,C'GHJKL',AND,
16,3,CH,EQ,19,3,CH),OR,
(1,6,CH,EQ,C' ',AND,7,6,CH,EQ,C' ',AND,
13,2,CH,EQ,C'88',AND,16,3,CH,EQ,19,3,CH))
|
|
|
