|
View previous topic :: View next topic
|
| Author |
Message |
jzhardy
Active User
Joined: 31 Oct 2006
Posts: 131
Location: brisbane
|
|
|
|
I have a set of FBA files (F1 ... F10 say). They are already sorted on a common key (pos 1 - 30), and I want to merge them together and split out into separate files. The split must ensure that records that have a common key value are kept together.
Eg -
F1 has
ID1 ... abc
ID1 ... def
ID2 ... xyz
F2 has
ID1 ... qwe
ID2 ... qaz
if i am splitting into (say) 2 files then I want something like :
F1 :
ID1 ... abc
ID1 ... def
ID1 ... qwe
F2 :
ID2 ... xyz
ID2 ... qaz
now this is easy to do in two steps - ie, merge into one file, and split out based on a test of a numeric value is position 1-30.
what i really want is to do this on one step - ie, go from one file (FBnnn) to N files of VBnnn in one step. can this be done ? |
|
| Back to top |
|
 |
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| now this is easy to do in two steps - ie, merge into one file, and split out based on a test of a numeric value is position 1-30 |
Why would you need two steps (passes)? Just do the MERGE and use OUTFIL statements to split off the records in one pass. |
|
| Back to top |
|
|
|
|
