how could i append "Date" to sequential file name

[jose.arunbabu]

Hi,

My requirment is to gnerate csv files like "<date>.csv " from datastageV8 at the target stage. Every time i run the job i need to get the with the todays date as its file name.

I have to get a solution on how to do this entirely in datastage itself.

Thanks in advance

Jose

[ray.wurlod]

Don't.

Generate xyz.csv and use an after-job subroutine to change the name of the file.

It's FAR easier.

[throbinson]

But carries baggage of it's own which may be too heavy. Like, an After routine is already defined for the job or such a simple task as renaming a file seems overly complicated to do it in two places, one fairly hidden in the GUI.
I like using a DS Macro for this;

Code: Select all

#DSJobStartDate#.csv

Everything has a downside and this one is that the file will be overwritten if you run the job more then once a day.

[rony_daniel]

But carries baggage of it's own which may be too heavy. Like, an After routine is already defined for the job or such a simple task as renaming a file seems overly complicated to do it in two places, one fairly hidden in the GUI.
I like using a DS Macro for this;

Code: Select all

#DSJobStartDate#.csv

Everything has a downside and this one is that the file will be overwritten if you run the job more then once a day.

That downside can also be taken care if another macro #DSJobStartTime# is added to the file name like #DSJobStartDate#_#DSJobStartTime#.csv

[throbinson]

That doesn't work on UNIX 7.5.3, neither does #DSJobStartTimeStamp# for this reason;

Sequential_File_15: When processing argument -fileWhen processing path: /tmp/2009-02-18_07:55:25.csv is not a valid path name: Invalid hostname: /tmp/2009-02-18_07

Are you saying it works on 8.x or yours (rony_daniel)?

[v2kmadhav]

Hello

If you can afford to use a parameter and call the job from a sequencer...
you can pass in
Convert('-: ','', DSJobStartTimestamp)
it would create your file as 20090218135610.csv

cheers

[chulett]

Both of those macros in filenames work fine for me - H-PUX, 7.5.1a, Server. Are you saying they don't work in PX jobs? Or are you saying that your flavor of UNIX does not allow the colons in the filename?

[throbinson]

My AIX 5.3 doesn't care about the colons. It appears to be EE. How about your EE?

[chulett]

Me no gots EE.

[throbinson]

Server - works
EE - Doesn't work because of the colon. A hardcoded test of a Sequential file name that contains a colon throws the same fatal warning;

Code: Select all

Sequential_File_15: When processing argument -fileWhen processing path: /tmp/todd:todd.csv is not a valid path name: Invalid hostname: /tmp/todd

and UNIX doesn't care either;

Code: Select all

touch todd:todd.csv
-rw-rw-r--   1 dstage            0 Feb 18 08:55 todd:todd.csv

[chulett]

I'm not aware of a UNIX that would care about the colons, but decided to ask. This smells like a bug... anyone report this to their support provider, gotten an official take on the issue?

[throbinson]

Just to completely beat this to death and then set it on fire, a colon is not allowed in a Windows filename.

[asorrell]

Hmm.. flaming colons...

Could have lived without that visual...

[ray.wurlod]

Apparently there are creams that you can use...

... or innuendoes (the old gags are best!)