Read Multiple text files from a folder

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
rajeev_prabhuat
Participant
Posts: 136
Joined: Wed Sep 29, 2004 5:56 am
Location: Chennai
Contact:

Read Multiple text files from a folder

Post by rajeev_prabhuat »

Hi,

I have created a job which takes data from a file which gives you job name, started and ended time of job etc. I want this to be used by multiple text files.

The job is like this, source file (SEQ.) will contain the output of DSjobReport for a job, and from that i will be taking only the needed columns using a transformer to a sequential file. This i want to do it for reading multiple text files from a particular folder and produce the result in another Seq file.

Regards,
Rajeev Prabhu
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I'm sorry, but is there a question in here somewhere? I could take a guess (mostly from the title of the thread) but I'd rather not. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Same solution as in previous thread with the following enhancements.
(1) Create one file of all the input files, using the TYPE command. Process the combined file.
(2) Change the constraint expression to Mod(@INROWNUM,6) = 0.
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