Complex Flat File using wildcards

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
IDC
Participant
Posts: 3
Joined: Fri May 21, 2010 8:46 am

Complex Flat File using wildcards

Post by IDC »

Hi all,
i'm using Complex Flat File stage to read from different .txt file so i set:

- In CFF stage
-- file type "File pattern"
-- file name(s) "C:\bla\bla\file_*.txt"

- In Environment variable
-- $APT_IMPORT_PATTERN_USES_FILESET = True

The job runs correctly but i need something that works like "file_name_column" option in Sequential file stage.

How can i get this functionality ?

Thanks Everybody for the help.
synsog
Premium Member
Premium Member
Posts: 232
Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune

Post by synsog »

Dear Experts, request you please provide your valuable inputs on the same . We have have a similar requirement like "IDC".

Thanks for your help and support in advance.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I do not believe that has ever been supported in the CFF stage. If true, as a workaround you could look into a looping Sequence job that calls the CFF job once per file found, passing in the filename to process as a parameter.
-craig

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