DSXchange

Hi,

I have a job where I read multiple files using the File pattern approach.
I also needed to get the file name , so I used the filename column option.

My file pattern is ??.txt.

While my job read all the data in the files correctly, the name in the filename column is always ??.txt. I was expecting to get 1a.txt, 2b.txt and so on.

Is this the way it is designed to work?

In case of file pattern,datastage perform just like unix "cat" command,since all the metadata of files are same,so its read bunches of the files togather.

But that is not my requirement, I need to map filename to each row

Set this environment variable APT_IMPORT_PATTERN_USES_FILESET to true and check.

That works!!!

FYI - a search here would have turned that information up.

Apologies Craig.
I Should have pointed towards it.

No worries! Just wanted to add that little tidbit.