How to execute an exe, dll or a batch file

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
aluthra48
Participant
Posts: 66
Joined: Thu Mar 05, 2009 9:59 am

How to execute an exe, dll or a batch file

Post by aluthra48 »

Can anyone say how one can execute an exe or a dll or a batch file in a DS job? And what if the exe is on another server? Can one execute it?

Thanks
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

If you can execute it from command line, you can certainly call it from a DataStage job using before/after job subroutine or command stage.
What have you tried so far?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Well... you don't execute a dll. And the others in several ways: DSExecute in a routine, ExecSH before/after job or Execute Command stage in a Sequence job.
-craig

"You can never have too many knives" -- Logan Nine Fingers
aluthra48
Participant
Posts: 66
Joined: Thu Mar 05, 2009 9:59 am

executing a vb generated exe

Post by aluthra48 »

No, I haven't checked it out, and I will. Can one specify a different server name in the path in the Execute command stage?

The exe is to be generated from a vb script

Thanks
chulett wrote:Well... you don't execute a dll. And the others in several ways: DSExecute in a routine, ExecSH before/after job or Execute Command stage in a Sequence job. ...
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No, that requires the use of some kind of "remote shell" capability outside of DataStage. You could script that, however, and then let DataStage execute the script.
-craig

"You can never have too many knives" -- Logan Nine Fingers
aluthra48
Participant
Posts: 66
Joined: Thu Mar 05, 2009 9:59 am

Post by aluthra48 »

Thanks
chulett wrote:No, that requires the use of some kind of "remote shell" capability outside of DataStage. You could script that, however, and then let DataStage execute the script. ...
Post Reply