file name

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
adams06
Participant
Posts: 92
Joined: Sun Mar 12, 2006 3:00 pm

file name

Post by adams06 »

Hi All,

How to create a file name with CurrentTimestamp?

I want to create a file in this form "filename_CurrentTimestamp.XLS"


Thanks in advance.
diamondabhi
Premium Member
Premium Member
Posts: 108
Joined: Sat Feb 05, 2005 6:52 pm
Location: US

Post by diamondabhi »

I think you can Use Timestamp as a JobParameter and use that parameter while naming the file.
Every great mistake has a halfway moment, a split second when it can be recalled and perhaps remedied.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

A search will find an after-stage subroutine that you can use. Generate the base name, then use the after-stage subroutine to change the name. Since the after-stage subroutine is not executed until all rows have been processed and the file closed, this is an entirely valid approach.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply