Dateformat

[parvathi]

Hi all,
I have requirement as follows
In datastage I need to pass the creationdate as a parameter to the nameof the file.
the parameter is
#ROOT#/DD_SAP_#DSJobStartTimestamp#_1.CSV

AFTER the job is run the name of file would like this
DD_SAP_2006-10-17 11:12:10_1.CSV IN UNIX SERVER

But I want to have the name of the file to look like this

DD_SAP_20061017111210_1.CSV


Is there anymethod i can modifythe dateformat during the runtime

can anybody suggest me

[kumar_s]

Other way is, you can produce the file as DD_SAP_1.CSV and you can use

Code: Select all

mv #ROOT#/DD_SAP_1.CSV #ROOT#/DD_SAP_`date +"%Y%m%d%H%M%S"`_1.CSV

in after job subroutine in ExecSH.