View previous topic :: View next topic
|
Author |
Message |
noorkh
New User
Joined: 06 Mar 2006 Posts: 76 Location: Chennai
|
|
|
|
Hi,
Below is a snippet of the data I need to sort .I want the header record- 10 as first record for their respective set -identified by the ID Number in the first 10 columns.Note set 1 and 3 have the same ID number , Hence cannot sort on ID no and the record type.The data in the header record varies .
4603787478 12WW PRAINGER
4603787478 13CK IMAGEWEAR
4603787478 14WW GRAINGER DCOF KA
4603787478 444603787478 399543
4603787478 47 9OZ EXCEL FR CONT
4603787478 100912010933523242313
4603838394 12WW PRAINGER
4603838394 13CK IMAGEWEAR
4603838394 14WW PRAINGER DCOF KA
4603838394 444603838394 460667
4603838394 47 9OZ EXCEL FR CONT
4603838394 100912010933523262313
4603787478 12WW PRAINGER
4603787478 13CK IMAGEWEAR
4603787478 14WW PRAINGER DCOF KA
4603787478 444603787478 399543
4603787478 47 9OZ EXCEL FR CONT
4603787478 47 9OZ EXCEL FR CONT
4603787478 100912010933523282313
The output should be as follows
4603787478 100912010933523242313
4603787478 12WW GRAINGER
4603787478 13VF IMAGEWEAR
4603787478 14WW GRAINGER DCOF KA
4603787478 444603787478 399543
4603787478 47 9OZ EXCEL FR CONT
4603838394 100912010933523262313
4603838394 12WW GRAINGER
4603838394 13VF IMAGEWEAR
4603838394 14WW GRAINGER DCOF KA
4603838394 444603838394 460667
4603838394 47 9OZ EXCEL FR CONT
4603787478 100912010933523282313
4603787478 12WW GRAINGER
4603787478 13VF IMAGEWEAR
4603787478 14WW GRAINGER DCOF KA
4603787478 444603787478 399543
4603787478 47 9OZ EXCEL FR CONT
4603787478 47 9OZ EXCEL FR CONT
Note:The header record 10 ,is now the first record for each set of data |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
What is the RECFM and LRECL of the input file?
What is the starting position, length and format of the ID number field?
What is the starting position, length and format of the record type field? |
|
Back to top |
|
|
|