To Append timestamp to file name:filename.MMDD.HHMM

[seemamone]

Hi,
We have a requirement to append timestamp of particular format
MMDD.HHMM to the file name.

Due to performance issues, we have to avoid using unix-scripting/routine for this purpose.

Any idea for adding this timestamp, in the same job,while the file is created, would be appreciated.

Cheers!

[chulett]

There would be no 'performance issue' with doing this in a script or after-job routine.

To do it in the job it must be a job parameter, then you can use it directly in the filename.

[ray.wurlod]

Due to performance issues, we have to avoid using unix-scripting/routine for this purpose.

Who said?
Ask someone who knows what they're talking about.

You ultimately have to execute a single UNIX mv command, irrespective of where you do it. As Craig said, there is no "performance issue".

Indeed, the overhead of not using a script is likely to be greater, since you can use the UNIX date command in the same command to give you your file name suffix.

Code: Select all

mv filename filename.`date "+%m%d.%H%M"`

[seemamone]

thanks for the reply to my earlier post:)
Do we have a DS command to translate the timestamp value as per our requirement, e.g : <MMDD>.<HHMM>

thanks in advance

[chulett]

Substring ( [] ) or OConv pairs with the proper coversion codes & masks, then concatenate with a dot between would do the trick. Assuming an ISO standard timestamp format:

Code: Select all

Convert("-","",YourTimestamp)[5,4] : "." : Convert("-","",YourTimestamp)YourTimestamp[10,4]

One example. You could also substring out the two parts with the dashes, concatenate them then do a 'post' convert to remove them. Always more than one way to skin the cat, as they say.

[seemamone]

i used left/right function in the derivation for calling the TIMESTAMP parameter in main sequence calling the job and it worked!!
phew, it was not that tough..but writing here, helped me develop this faster!!
u guys rock!!
this was my 1st post and i am already finding it so useful!!!

[jdmiceli]

Welcome aboard and we're glad your first experience was a positive one!

Merry Christmas!