Data and Time for the sequential file.

[highpoint]

Hi,

I want the sequential file name to have Date and Time in the following fomat.

20110610_124801

I am creating this as a variable in user varaiables activity and passing it is as parameter to job.


I am using the following:

Code: Select all

OCONV(DATE(), "D4-YMD[4,2,2]"): '_':OCONV(TIME(), "MTS") 

This returns:

2011-06-10_12:43:11

Sequential file name does not like ":" in its name.

I have gone through forum search. Could not find anything that suits me.


Help is appreciated to modify the OCONV to suit my format of

20110610_124801

[samyamkrishna]

in the file name do not give colon ':'

Or create two variable one for date and one for time and use it as in the sequential file stage.

#PATH#'/'#FILENAME##DATE#'_'#TIME#

this should work

[highpoint]

How are you generating DATE and TIME in user variable activity.

This should be generated during run time

[samyamkrishna]

using functions the same you are doing above.
But instead of one variable create two variables and use them the file stage

[highpoint]

Then time will have colon in it

[samyamkrishna]

remove them inside the job. what are the stage you are using.
If there is a transformer stage you can easily remove it.

[highpoint]

As mentioned above i am creating this in user variable activity.

[samyamkrishna]

ar eyou using a transformer stage in the job?

[chulett]

As noted, remove them if you don't want them in the final output:

Code: Select all

Convert("-:","",OCONV(DATE(), "D4-YMD[4,2,2]"): '_':OCONV(TIME(), "MTS"))

[mobashshar]

If you are using Current Date and Time for file creation.. then do the following:

Create the file with a generic name like outfile
Use After Job Subroutine and ExecSH and do the following:
mv outfile outfile.`date +"%m%d%y%H%M%S"`

Done!

[ray.wurlod]

Code: Select all

Oconv(Date(), "D4YMD[4,2,2]" : @VM : "MCN") :  "_" : Oconv(Time(), "MTS" : @VM : "MCN")