Page 1 of 1

Reading multiple input files into a funnel stage using sym

Posted: Thu Feb 15, 2007 5:02 pm
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?

Posted: Thu Feb 15, 2007 5:41 pm
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.

Posted: Thu Feb 15, 2007 6:03 pm
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.

Posted: Thu Feb 15, 2007 7:46 pm
by chulett
"Symbolic" = "wildcard" I do believe.