Exec Dos Command

Umbix62 · Post by **Umbix62** » Mon Mar 20, 2006 3:48 am

Hi there

I have to exec a Dos command in the before routine as this:

"Echo 2006/03/20 > pippo.dat"

to create a flat file at the end of this job, if it run without errors. In this file I have to insert only one row with the current data, as for example "2006/03/20". How can I do that? I can put the current date in the command, using for example, the DataStage variable @date? I know I can use a parameter contained the current date but I'ld know if there is a direct method to do that without using parameters.

Thank you

Umberto

ArndW · Post by **ArndW** » Mon Mar 20, 2006 4:29 am

Umberto,

I am not sure about what you need to do; you posted the question as a UNIX server one, but are asking about DOS; you stated that you want a "before routine" to do something after the job completes successfully.

If you has a DOS server installation, you can simply execute

Code: Select all

date /t > pippo.dat

as a shell command to put the current system date into a file.

chulett · Post by **chulett** » Mon Mar 20, 2006 7:49 am

Make sure you enable the 'Only run after successful completion' option.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 20, 2006 12:43 pm

A similar approach for UNIX also involves the date command; the picture option is set according to your requirements. For example

Code: Select all

date +"%yyyy-%MM-%dd" > bippo.dat

But, as Arnd noted, we are not sure whether you are asking about UNIX (your job type in post header) or DOS (your post body).

Umbix62 · Post by **Umbix62** » Tue Mar 21, 2006 3:22 am

ArndW wrote:Umberto,

I am not sure about what you need to do; you posted the question as a UNIX server one, but are asking about DOS; you stated that you want a "before routine" to do something after the job completes successfully.

If you has a DOS server installation, you can simply execute
Code: Select all
date /t > pippo.dat
as a shell command to put the current system date into a file.

Ok, it works. Thank you very much. I did it in a Unix environment with touch command. Now I work in a Windows 2003 Server and I don't know the Dos Command.

Thank you again to everybody

Umberto

ray.wurlod · Post by **ray.wurlod** » Tue Mar 21, 2006 4:17 am

touch.exe ships with DataStage. It can be found in the Engine folder's bin subdirectory.

Umbix62 · Post by **Umbix62** » Wed Mar 22, 2006 3:50 am

ray.wurlod wrote:touch.exe ships with DataStage. It can be found in the Engine folder's bin subdirectory. ...

This is the command I used in a Unix environment. I can't access this subdirectory. I have decided to use the command suggested "date /t > filename.dat". If I want to write in that flat file the current date and time?

Thank you

Umberto

ArndW · Post by **ArndW** » Wed Mar 22, 2006 3:57 am

Umberto,

just as with date /t you can use the time /t command to get the current time output in dos.

Umbix62 · Post by **Umbix62** » Wed Mar 22, 2006 3:59 am

ArndW wrote:Umberto,

just as with date /t you can use the time /t command to get the current time output in dos. ...

Ok, but if I want write togheter and not only one?

kumar_s · Post by **kumar_s** » Wed Mar 22, 2006 4:12 am

You can append one after other.
date /t > filename.dat
time /t >> filename.date

ArndW · Post by **ArndW** » Wed Mar 22, 2006 4:17 am

Try "echo %DATE% %TIME% > filename.dat"

Umbix62 · Post by **Umbix62** » Wed Mar 22, 2006 4:20 am

ArndW wrote:Try "echo %DATE% %TIME% > filename.dat" ...

Ok, it works. Thank you very much

Umberto