|
View previous topic :: View next topic
|
| Author |
Message |
ywheeler
New User
Joined: 10 Nov 2006
Posts: 19
Location: New York
|
|
|
|
I am trying to CHANGE a value in a field using sort. I have one sortin file which I need to :
SORT FIELDS= (1,8,CH,A)
OUTFIL FNAMES=SORTOF1...
OUTFIL FNAMES=SORTOF2...
1) SORTOF1 = THE FULL SORTIN FILE
2) SORTOF2 = the full sortin and change a value in a field if another field has a certain criteria.
example.
Layout : pos 1-8 Name
pos 9-13 T-Nbr
pos 14-18 S-Nbr
SORTOF2 OUTREC=(1,8, IF T-NBR = 12345 THEN S-NBR = 65987 ELSE S-NBR = S-NBR)
Thanks.
 |
|
| Back to top |
|
 |
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
You can use these DFSORT control statements to do what you asked for:
| Code: |
SORT FIELDS=(1,8,CH,A)
OUTFIL FNAMES=SORTOF1
OUTFIL FNAMES=SORTOF2,
IFTHEN=(WHEN=(9,5,CH,EQ,C'12345'),
OVERLAY=(14:C'65987'))
|
|
|
| Back to top |
|
|
ywheeler
New User
Joined: 10 Nov 2006
Posts: 19
Location: New York
|
|
|
|
| Frank, Thanks so much. |
|
| Back to top |
|
|
|
|
