Sequential File FILE_NAME option

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
mczern
Premium Member
Premium Member
Posts: 80
Joined: Thu Jan 20, 2005 8:38 am
Location: Atlanta, GA
Contact:

Sequential File FILE_NAME option

Post by mczern »

I would like to have the file name associated with a record added to each record so I can process the records in order. The file name starts with X and has a date time added to the end of the name. When I added the FILE_NAME option and the READ METHOD = File Pattern and set the File Pattern to X*... It added X* as the FILE_NAME column value for every record.

I was expecting the FILE_NAME column to contain X_02.05.2009.3243243, X_02.03.2009.3123231, etc. This is not very useful in that there are duplicate keys in the files and the file_name was supposed to make the records unique.

Has anyone else run into this situation and fixed it?
Mike Czerniawski
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Could this be another 8.0 bug? It works ok in 7.5.1.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Mike
Premium Member
Premium Member
Posts: 1021
Joined: Sun Mar 03, 2002 6:01 pm
Location: Tampa, FL

Post by Mike »

An exact search on "file pattern" turns up a number of resolved threads...

For example... viewtopic.php?t=121263&highlight=file+pattern

Mike
mczern
Premium Member
Premium Member
Posts: 80
Joined: Thu Jan 20, 2005 8:38 am
Location: Atlanta, GA
Contact:

Post by mczern »

Thanks Mike! The link worked.
I need to go to a remedial forum search class.
Mike Czerniawski
Post Reply