DSXchange

I am calling a script in the execute command stage and would like to parameterize the path of the shell script.
what is the syntax for it?

Thanks

Just enclose the parameter name in pound/hash/# marks like usual.

There is a known bug in older versions of DataStage where this does not work. Let us know your version.

7.5.2

No bug there, so...

chulett wrote: Just enclose the parameter name in pound/hash/# marks like usual.

I am getting this error "executable path cannot contain parameters"


In the command field I want to parametrize the path ?
Any advice would be appreciated.
Thanks

You can call the command from within a shell. The input box that takes in the command would execute a command to create a new instance of a shell and the parameters would be the path of the command that you want to run.

I do this in windows. For example if I want to execute c:\var_path\mike.exe where the path is dynamic I would set it up like this.

Command input box:

CMD.EXE

Parameters input box:

/C #jpVarPath#mike.exe #jpParam1# #jpParam2#

michaeld wrote:You can call the command from within a shell. The input box that takes in the command would execute a command to create a new instance of a shell and the parameters would be the path of the command that you want to run.

I do this in windows. For example if I want to execute c:\var_path\mike.exe where the path is dynamic I would set it up like this.

Command input box:

CMD.EXE

Parameters input box:

/C #jpVarPath#mike.exe #jpParam1# #jpParam2#

Michael my script is in unix box ( /home/folder/filename.sh)
I tried using CMD.sh in command field and in the parameter field #param# which has the whole path of the script , , but it doesnt work.
"Output from command ====>
SH: line 1: CMD.sh: command not found"
Any idea what am I doing wrong here?

Thanks

That example was Windows specific. Try using plain old 'sh' instead.

chulett wrote:That example was Windows specific. Try using plain old 'sh' instead. ...

It worked, Thanks Michael and Chulett..