Dynamic Time Stamp

JDionne · Post by **JDionne** » Thu Oct 23, 2003 7:20 am

I have a process currently in SQL server that runs a query and outputs a string of date time information into a batch file. Then I run the batch file to rename a load file. I am moving away from sql server and using DataStage as my data processing tool of choice. Is there a way for data stage to dynamicaly produce a name for a file and rename it?
Jim

Peytot · Post by **Peytot** » Thu Oct 23, 2003 7:43 am

I don't think so. I think you need to use an After Subroutine to rename it with a system variable.

Pey

spracht · Post by **spracht** » Thu Oct 23, 2003 8:51 am

A couple of weeks ago, Michael Hester pointed out that you can use DS makros just like job parameters, surrounded by hashes, to achieve that.

JDionne · Post by **JDionne** » Thu Oct 23, 2003 9:08 am

spracht wrote:A couple of weeks ago, Michael Hester pointed out that you can use DS makros just like job parameters, surrounded by hashes, to achieve that.

How would I search to find that post so that I can figure it out?
What was the tipc subject?
Jim

spracht · Post by **spracht** » Thu Oct 23, 2003 9:27 am

Can't remember, try to use

DSJobStartDate
DSJobStartTime
DSJobStartTimestamp

in your file name specification. like

file#DSJobStartDate#.txt to get 'file_2003-10-23.txt' as your file name.

JDionne · Post by **JDionne** » Thu Oct 23, 2003 9:30 am

spracht wrote:Can't remember, try to use

DSJobStartDate
DSJobStartTime
DSJobStartTimestamp

in your file name specification. like

file#DSJobStartDate#.txt to get 'file_2003-10-23.txt' as your file name.

that makes sence....but where do i put that to rename the original data file? after job completion.....

spracht · Post by **spracht** » Thu Oct 23, 2003 9:31 am

I found it:

viewtopic.php?t=85059

and sorry, It wasn'r Michael but ariear

spracht · Post by **spracht** » Thu Oct 23, 2003 9:39 am

To rename a file you can use a similar synatax in an after- job subroutine, like (how was this in Windows?): ren file file_#DSJobStartDate#.txt. In Unix, I would probably use the OS to create the new filename, like:

mv file file_$(date '+%Y%m%d').txt

JDionne · Post by **JDionne** » Thu Oct 23, 2003 9:47 am

spracht wrote:To rename a file you can use a similar synatax in an after- job subroutine, like (how was this in Windows?): ren file file_#DSJobStartDate#.txt. In Unix, I would probably use the OS to create the new filename, like:

mv file file_$(date '+%Y%m%d').txt

Im testing that now..Ill let you know whats happening
Jim

JDionne · Post by **JDionne** » Thu Oct 23, 2003 9:59 am

worked like a charm
Thanx
Jim

JDionne · Post by **JDionne** » Thu Oct 23, 2003 10:52 am

JDionne wrote:worked like a charm
Thanx
Jim

If i wanted to run two dos commands after job has run do i seperate them with a ; ?
Jim