Page 1 of 1

Parameter passing

Posted: Thu May 10, 2007 7:57 am
by mayods1
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

Posted: Thu May 10, 2007 8:08 am
by csrazdan

Posted: Thu May 10, 2007 8:08 am
by mctny
did you try to pass those parameters within a single or double quote?

Posted: Thu May 10, 2007 8:21 am
by csrazdan
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 

Posted: Thu May 10, 2007 8:49 am
by mayods1
mctny wrote:did you try to pass those parameters within a single or double quote?
Both

Posted: Thu May 10, 2007 10:25 am
by diamondabhi
Has this been resolved, could you post the script you are using.