execute command stage

[dspxguy]

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

[chulett]

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

[kduke]

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

[dspxguy]

7.5.2

[chulett]

No bug there, so...

[dspxguy]

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

[michaeld]

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#

[dspxguy]

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

[chulett]

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

[dspxguy]

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

It worked, Thanks Michael and Chulett..

[ray.wurlod]

Please mark thread as Resolved