DSXchange

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:

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

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

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

This should be generated during run time

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

Then time will have colon in it

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

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

ar eyou using a transformer stage in the job?

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

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!