Date and time setup for sequential file stageYYYYMMDDHH24

mandyli · Post by **mandyli** » Tue Nov 18, 2008 10:59 am

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

chulett · Post by **chulett** » Tue Nov 18, 2008 11:09 am

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.

skbodla · Post by **skbodla** » Thu Dec 11, 2008 7:52 am

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. ...

chulett · Post by **chulett** » Thu Dec 11, 2008 8:11 am

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.

seshikumar · Post by **seshikumar** » Tue Dec 16, 2008 7:43 am

i have done same requiremnt by passing the parameters throw shell scripts....i

DSXchange