Append system date and time to a file name in Seq File Stag

[chulett]

You'd need to pass those values in as job parameters to use them in the filename when created. Another option is to create a static filename and then rename it / add the timestamp after job, typically via a generic script.

[ambasta]

After generating the file ..use after job subroutine or Unix shell script to rename the file

[franck0677]

You'd need to pass those values in as job parameters to use them in the filename when created. ...

Hi, thanks for your explanation but could you give some details around the syntax of that. Around passing this values in as job parameters.
Some exemples ?
Thanks.

[chulett]

For example, assuming a job parameter named FILE_TIMESTAMP, you would specify the filename as:

FileName_#FILE_TIMESTAMP#.txt

Does that help?

[franck0677]

For example, assuming a job parameter named FILE_TIMESTAMP, you would specify the filename as:

FileName_#FILE_TIMESTAMP#.txt

Does that help? ...

OK thank u, and we used oconv to assign the good value to the parameter.

[franck0677]

For example, assuming a job parameter named FILE_TIMESTAMP, you would specify the filename as:

FileName_#FILE_TIMESTAMP#.txt

Does that help? ...

OK thank u, and we used oconv to assign the good value to the parameter.

[srimitta]

Or you can pass Timestamp as part of File name ( FileName_#FILE_TIMESTAMP#.txt) dynamically from Sequencer job or Job Control job.

[srimitta]

Or you can pass Timestamp as part of File name ( FileName_#FILE_TIMESTAMP#.txt) dynamically from Sequencer job or Job Control job.

[chulett]

You might want to expand on that a little, seeing as how you cannot have a parameter value that references another parameter.

[GSIDSXGrp]

The method I used to get a sequence file name that includes the current date:

In the Parallel Job add a Parameter for the Current Date. In the Sequential File stage include the parameter in the File: myfile_#Current_Date#.txt

Create a Sequence Job. Add UserVariables Activity Stage. In the UserVariables stage add a variable in User Variables named TODAY_YYYYMMDD with Expression convert('-','',oconv(@DATE, "D4-YMD[4,2,2]"))

Add my Parallel Job as a Job Activity Stage to the Sequence Job. Link with UserVariables to Job Activity. In Job Activity Parameters, Insert the Parameter from UserVariables Stage.

[tbtcust]

Thanks GSIDSXGrp. Your solution works great.