How to append the 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
rajkraj
Premium Member
Premium Member
Posts: 98
Joined: Wed Jun 15, 2005 1:41 pm

How to append the data????

Post by rajkraj »

I have 4 sequential files with same fields(no keys) but different data...how can I make those 4 files to 1 sequential file. Help me...

thanks in advance.

Raj
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

Use a link collector at the end and write it to one flat file, hope it helps.
rcil
Charter Member
Charter Member
Posts: 70
Joined: Sat Jun 05, 2004 1:37 am

Re: How to append the data????

Post by rcil »

Raj,

You can use a UNIX cat command to concatinate all the 5 files into one by executing the command using ExecSh in before or after routine based on your requirement.

Hope that helps.
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

You can write your cat command in the sequential file as filter.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Process them in separate jobs, run consecutively, with the writing rule set to Append.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply