How to process 3 sequential files sequentially

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
senani
Participant
Posts: 2
Joined: Fri Sep 09, 2005 1:20 am

How to process 3 sequential files sequentially

Post by senani »

How to process 3 sequential files sequentially one by one, How can I do that while processing the files it should fetch files automatically?
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

You haven't been very clear about exactly what your problem is, but here's a guess at 2 possible answers:

1. use "cat" to concatenate all 3 files to one file and process that one.
2. Use a loop in a sequence to call a job, passing each file name as a parameter to the job
m_keerthi2005
Participant
Posts: 22
Joined: Thu Jun 02, 2005 5:12 am

Re: How to process 3 sequential files sequentially

Post by m_keerthi2005 »

senani wrote:How to process 3 sequential files sequentially one by one, How can I do that while processing the files it should fetch files automatically?
hi,

If the table structure is same in all the text files, then you can use link collector to load data into a single file.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Or,
Create a Multiple instance job, and schedule three JobActivity in the JobSequence, each reading the three files sequentially.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
vcannadevula
Charter Member
Charter Member
Posts: 143
Joined: Thu Nov 04, 2004 6:53 am

Re: How to process 3 sequential files sequentially

Post by vcannadevula »

You can use the folder stage to process the 3 files too
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Re: How to process 3 sequential files sequentially

Post by gateleys »

You can also use the Filter command within the sequential file. For Windows, use TYPE, and for UNIX the CAT command.
Post Reply