Page 1 of 1
Date and time setup for sequential file stageYYYYMMDDHH24
Posted: Tue Nov 18, 2008 10:59 am
by mandyli
Hi
I am creating one flat file with following format from Oracle table.
This is simple and direct mapping job.
The File format is abc_YYYYMMDDHH.txt.
In the sequential file stage how will i integrate file name with current date and time.
Thanks in advance
Posted: Tue Nov 18, 2008 11:09 am
by chulett
Either pass the "date time" in as a Job Parameter and #include# it in the filename or create a static filename and rename it after job to include that information.
how to set date time to job parameter in 8.0
Posted: Thu Dec 11, 2008 7:52 am
by skbodla
how to set date time to job parameter in 8.0
chulett wrote:Either pass the "date time" in as a Job Parameter and #include# it in the filename or create a static filename and rename it after job to include that information. ...
Posted: Thu Dec 11, 2008 8:11 am
by chulett
Same way as in any other version - typically, a routine that gets and formats the time. A Routine Activity in a Sequence job can then easily pass it to the job. @DATE, @TIME, TimeDate() etc can be used to get this information.
Re: Date and time setup for sequential file stageYYYYMMDDHH2
Posted: Tue Dec 16, 2008 7:43 am
by seshikumar
i have done same requiremnt by passing the parameters throw shell scripts....i