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?
Sequential File FILE_NAME option
Moderators: chulett, rschirm, roy
Sequential File FILE_NAME option
Mike Czerniawski
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
An exact search on "file pattern" turns up a number of resolved threads...
For example... viewtopic.php?t=121263&highlight=file+pattern
Mike
For example... viewtopic.php?t=121263&highlight=file+pattern
Mike