Merging Data

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vskr72
Premium Member
Premium Member
Posts: 128
Joined: Wed Apr 28, 2004 9:36 pm

Merging Data

Post by vskr72 »

I have a folder which has few Seqeuntial file names. The number of files names can vary every time. I need to merge data from all these files and store it in a new Seq file for further processing.

Can anybody help me on how to handle this? Thank you.

Kumar
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Any problem using the unix command cat?
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

vskr72,

how about using a folder stage to selectively get the filenames you wish to process, then a simple SeqFile->SeqFile type job with the output file NOT being overwritten, but appended to. It lacks the intrinsic simplicity and elegance of Ken's solution [I'd recommend his suggestion, execute a single efficient UNIX command].
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

....make sure that your target file is not created in the same directory.
Post Reply