Unix scripts from Datastage job
Moderators: chulett, rschirm, roy
Unix scripts from Datastage job
Is there any way we can execute a UNIX script from a Datastage job ?
ps
Re: Unix scripts from Datastage job
Hi
Yes,Execute command activity in the sequencer.
Yes,Execute command activity in the sequencer.
Is there any way we can execute a UNIX script from a Datastage job ?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
(1) Before/after subroutine in job
(2) Call DSExecute() subroutine with "SH" as Arg1
(3) Execute Command activity in job sequence
(There are other ways, but these are the most commonly used.)
(2) Call DSExecute() subroutine with "SH" as Arg1
(3) Execute Command activity in job sequence
(There are other ways, but these are the most commonly used.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi Ray,
Thank for the answers. But DSExecute says that the "Command option" (withing the DSExecute) should not prompt for an input (like below).
_____________________________________________________________
Call DSExecute(ShellType, Command, Output, SystemReturnCode)
ShellType (input) specifies the type of command you want to execute and is either "NT" or "UV" (for DataStage Engine)).
Command (input) is the command to execute. Command should not prompt for input when it is executed.
-------------------------------------------------------------------------------------
And I need to execute a UNIX script from within a Datastage job. So do you think I can do this with the DSExecute or should I use some other command.
Thank for the answers. But DSExecute says that the "Command option" (withing the DSExecute) should not prompt for an input (like below).
_____________________________________________________________
Call DSExecute(ShellType, Command, Output, SystemReturnCode)
ShellType (input) specifies the type of command you want to execute and is either "NT" or "UV" (for DataStage Engine)).
Command (input) is the command to execute. Command should not prompt for input when it is executed.
-------------------------------------------------------------------------------------
And I need to execute a UNIX script from within a Datastage job. So do you think I can do this with the DSExecute or should I use some other command.
ps
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's correct that scripts can not prompt for input when invoked from DataStage (by whatever method). This is because DataStage processes are background processes.
Nowhere in this thread has any requirement to prompt for input been mentioned. Therefore all answers given have been valid.
Do you REALLY want to invoke an interactive script in a non-interactive environment? Why? If so, make a "here script" that can supply the inputs.
If you had provided some kind of insight as to what you want to do, maybe more exact answers could have been given.
It was not necessary to send a Private Message as well.
Nowhere in this thread has any requirement to prompt for input been mentioned. Therefore all answers given have been valid.
Do you REALLY want to invoke an interactive script in a non-interactive environment? Why? If so, make a "here script" that can supply the inputs.
If you had provided some kind of insight as to what you want to do, maybe more exact answers could have been given.
It was not necessary to send a Private Message as well.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.