Reading multiple input files into a funnel stage using sym

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
UPS
Premium Member
Premium Member
Posts: 56
Joined: Tue Oct 10, 2006 12:18 pm
Location: New Jersey

Reading multiple input files into a funnel stage using sym

Post by UPS »

I am attempting to have multiple input files with same file name execpt for symbolic , like state, into a funnel. How can I use a symbolic in job parm to grap all files?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Don't use a funnel stage. Use a single Sequential File stage, with the File Mode property set to "File Pattern" and specify a regular expression for extracting the files in question. They must, of course, all have the same record structure - but that would also be true to use a Funnel stage.

If there are only specific, known file names you want to read, you can use "Specific File" as the File Mode property and as many File properties (each containing a specific pathname) as your require.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

What exactly do you mean by "symbolic"? I did not get that.
Never the less, Ray has pointed out two appropriate methods to get your work done.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

"Symbolic" = "wildcard" I do believe.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply