How to read multiple files using sequential stage?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
nareshketepalli
Participant
Posts: 36
Joined: Mon Jun 28, 2010 11:24 pm
Location: seepz

How to read multiple files using sequential stage?

Post by nareshketepalli »

How to read multiple files using sequential stage?
NARESHKUMAR
samyamkrishna
Premium Member
Premium Member
Posts: 258
Joined: Tue Jul 04, 2006 10:35 pm
Location: Toronto

Re: How to read multiple files using sequential stage?

Post by samyamkrishna »

Choose read method as File pattern.
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

You can also specify multiple files in the filename option of the Sequential File stage, or an O/S command which will return multiple filenames.

File pattern, as mentioned above, will work well as long as your files are consistently named to meet the pattern requirements.

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Yet another method is to use a Filter command using (for example) a cat command.
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