File Pattern

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
manjuak.boya1@gmail.com
Participant
Posts: 4
Joined: Tue Apr 19, 2011 12:11 pm

File Pattern

Post by manjuak.boya1@gmail.com »

in sequential stage we give file patters but it reads multiple files at a time but how to read one by one
hasi
datastage developer
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I've been deleting these wayward posts up till now but took pity on this one for some reason, so split it out to here.
-craig

"You can never have too many knives" -- Logan Nine Fingers
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

If "one by one" means a separate run of the processing job for each file, that's what a Sequence job with the Start/End Loop stages will do. Any particular problem with doing them all at once?
-craig

"You can never have too many knives" -- Logan Nine Fingers
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

Have you tried setting the option "Keep file partitions" to "True"? I haven't used it in a long time, but I think that may do what you are looking for - keep the data from each file together in a single partition.

For example if you have four files that are read, the data would be output in four partitions, one for each file. You'd still have to be concerned about re-partitioning later in the job by other stages.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
Post Reply