Huan-Nguyen
New User
Joined: 17 Jan 2006
Posts: 17
|
|
|
|
I have a file, all records in that file that contains Key field (5 bytes) & Data field, I would like to create a file with all the Key field = AAAAA , a file with all the Key field = BBBBB and if any key field is not equal AAAAA or BBBBB I wand to create a file with a default key field = XXXXX
EX: Input file
AAAAA vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
AAAAB VVVVVVVVVVVVVVVVVVVVVVVVVVVVxxxxx
AAAAA HHHHHHHHHHHHHHHHHHHHVVVVVVVVVVVVV
AAACD BBBBBBBBBBBBBBBBBBBBXXXXXXXXXXXXX
BADRC BBBBBBBBBBBBBBXXXXXXXXXXXXXXXXXXX
BBBBB NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
XXXXX TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT
BBBBB VVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVV
Output in File-01
AAAAA vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
AAAAA HHHHHHHHHHHHHHHHHHHHVVVVVVVVVVVVV
Output in File-02
BBBBB NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
BBBBB VVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVV
Output in File-03
XXXXX VVVVVVVVVVVVVVVVVVVVVVVVVVVxxxxx
XXXXX BBBBBBBBBBBBBBBBBBBBXXXXXXXXXXXXX
XXXXX BBBBBBBBBBBBBBXXXXXXXXXXXXXXXXXXX
XXXXX TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT
How can I use DF-SORT to get the 3 files like that ??? |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
Here's a DFSORT job that will do what you asked for:
| Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file
//OUT1 DD DSN=... output file1
//OUT2 DD DSN=... output file1
//OUT3 DD DSN=... output file1
//SYSIN DD *
OPTION COPY
OUTFIL FNAMES=OUT1,INCLUDE=(1,5,CH,EQ,C'AAAAA')
OUTFIL FNAMES=OUT2,INCLUDE=(1,5,CH,EQ,C'BBBBB')
OUTFIL FNAMES=OUT3,SAVE,OVERLAY=(1:C'XXXXX')
/*
|
|
|
