Parameter passing

mayods1 · Post by **mayods1** » Thu May 10, 2007 7:57 am

Anyone know how to pass parameters to DataStage via a shell script calling dsjob when the parameter value has spaces in it? I.e. Select Name from Customer

As long as there are no spaces in the parameter value, it works fine, but I get a -9999 DSJE_DSJOB_ERROR when I try to pass the parameter value with spaces in it.

Thanks

csrazdan · Post by **csrazdan** » Thu May 10, 2007 8:08 am

Refer to following post for answer:

http://www.dsxchange.com/viewtopic.php ... b93a07aa2

mctny · Post by **mctny** » Thu May 10, 2007 8:08 am

did you try to pass those parameters within a single or double quote?

csrazdan · Post by **csrazdan** » Thu May 10, 2007 8:21 am

Double quote.

Following is how your command should look like:

Code: Select all

eval /opt/tools/ds/Ascential/DataStage/bin/dsjob -run -wait -param DsName="Thomos E Edison" -warn 5 Project_Name Job_Name

mayods1 · Post by **mayods1** » Thu May 10, 2007 8:49 am

mctny wrote:did you try to pass those parameters within a single or double quote?

Both

diamondabhi · Post by **diamondabhi** » Thu May 10, 2007 10:25 am

Has this been resolved, could you post the script you are using.