Hi,
I like to dynamically create a name for the outputfile for a sequential file stage. The form must be like "d:\datastage\output\file_YYYYMMDD.csv" where YYYYMMDD has to be the current date. How can I accomplish this? I tried with a user defined routine, but that's not working (either because I'm calling it the wrong way or because it ain't possible).
Thanks in advance,
Aart
Dynamic filename for sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Alternatively, always write to the same, standard, file name and use an after-stage or after-job subroutine to compute the dynamic file name and rename the file.
(This is much easier on UNIX, where the output of the date command can be captured within the mv command, but I note that you are on Windows.)
(This is much easier on UNIX, where the output of the date command can be captured within the mv command, but I note that you are on Windows.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 70
- Joined: Thu Aug 14, 2003 6:24 am
- Contact: