Page 1 of 1

Invoking Dos Commands through Datastage

Posted: Fri Apr 20, 2007 7:59 am
by Lotus26
Hi

I am Using Server Edition and My DataStage is Installed on Unix Box . But I want to execute some DOS Commands like from Datastage.
Is it Possible to do so like invoking the DOS Commands through DataStage ??

I would appreciate any help on this . Thanks.

Posted: Fri Apr 20, 2007 8:03 am
by michaeld
In a sequence job there is a command activity stage. You can run commands through it the same as you would from a shell.

Posted: Fri Apr 20, 2007 8:04 am
by DeepakCorning
There are many ways , to start with there is a command stage..you can use that,..

Re: Invoking Dos Commands through Datastage

Posted: Fri Apr 20, 2007 8:14 am
by Lotus26
But My Files are on Windows Box. I wonder is this possible still like use the execcommand stage in Sequencer??

Thanks.

Posted: Fri Apr 20, 2007 8:16 am
by DSguru2B
Maybe remote shell :?: Or install samba, this way windoze will become transparent and you can see/execute files on windoze.

Invoking Dos Commands

Posted: Fri Apr 20, 2007 8:26 am
by Lotus26
DSguru2B wrote:Maybe remote shell :?: Or install samba, this way windoze will become transparent and you can see/execute files on windoze.

So through Datastage can I invoke Samba or remoteshell and that way I can execute the DOS Commands on the files which are on Windows box??

Thanks.

Posted: Fri Apr 20, 2007 8:31 am
by DSguru2B
Yes. Search for "remote shell", it has been covered before.

Posted: Sat Apr 21, 2007 10:07 am
by kcbland
The only way to run a DOS command is to clarify which PC you wish to use. Then, use remsh or ssh to run a remote command on a Windoze machine. This Unix program can be executed using a Command stage in a Sequence, which simply calls the DSExecute API. You can do the same within a Batch job or thru a custom function/routine.