Page 1 of 1
Posted: Fri Sep 19, 2008 8:02 am
by 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.
Posted: Fri Sep 19, 2008 10:19 pm
by ambasta
After generating the file ..use after job subroutine or Unix shell script to rename the file
More details please ?
Posted: Tue Sep 23, 2008 3:08 am
by franck0677
chulett wrote: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.
Posted: Tue Sep 23, 2008 8:01 am
by chulett
For example, assuming a job parameter named FILE_TIMESTAMP, you would specify the filename as:
FileName_#FILE_TIMESTAMP#.txt
Does that help?
Posted: Tue Sep 23, 2008 8:31 am
by franck0677
chulett wrote: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.
Posted: Tue Sep 23, 2008 8:32 am
by franck0677
chulett wrote: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.
Posted: Tue Sep 23, 2008 9:14 am
by srimitta
Or you can pass Timestamp as part of File name ( FileName_#FILE_TIMESTAMP#.txt) dynamically from Sequencer job or Job Control job.
Posted: Tue Sep 23, 2008 9:15 am
by srimitta
Or you can pass Timestamp as part of File name ( FileName_#FILE_TIMESTAMP#.txt) dynamically from Sequencer job or Job Control job.
Posted: Tue Sep 23, 2008 9:17 am
by chulett
You might want to expand on that a little, seeing as how you cannot have a parameter value that references another parameter.
Posted: Wed Sep 24, 2008 10:22 am
by 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.
Posted: Sat Oct 25, 2008 9:01 pm
by tbtcust
Thanks GSIDSXGrp. Your solution works great.