DSXchange

We have a requirement where we need to pass quoted parameters do the dsjob command

dsjob -run -param acctype='a b c' <project name> <job name>

But ds comes back with an invalid argument message. If we remove the spaces between the values, it works

dsjob -run -param acctype='abc' <project name> <job name>

Can you pls let me know if you have come across similar scenarios and what you did to over come this problem?

Thanks

That is a question of how UNIX give the data to DataStage.

Best might be you pass "'a*b*c' and substitute within DataStage the star with a blank.

Put eval before dsjob (eval dsjob -run -param ) or include the parameter name also into the quote and try.

Try

dsjob -run -param 'acctype=a b c' <project name> <job name>

Thank you for your suggestions. we tried all the suggestions but none of them produced the desired results.

Thanks.

Can you post your exact error message?

Did you try escaping the quote characters?

Ray,

While using the escape character, it comes back with a message

Invalid arguments: dsjob -run
[-mode <NORMAL | RESET | VALIDATE>]
[-param <name>=<value>]
[-warn <n>]
[-rows <n>]
[-wait]
[-opmetadata <TRUE | FALSE>]
[-disableprjhandler]
[-disablejobhandler]
[-jobstatus]
[-userstatus]
[-local]
[-useid]
<project> <job|jobid>

Status code = -9999 DSJE_DSJOB_ERROR

If we just past the quote character without the escape character, it runs but truncates the value at the first space.

Thanks

Guessing this should work, if you want to pass 'a b c' as the parameter value.
HTH

We have thried that as well and it does not work.

Thanks

Mhh.. If possible can you give the exact command that you are using.
Looks like we are missing something here.

we just progressed a step ahead. The original command I was trying to execute was in the project directory with the -local option, it does not work...as below.

/app/dsadm/Ascential/DataStage/DSEngine/bin/dsjob -run -wait -warn 0 -param SRCE_SYS_NM="I P" -local <ProjName> JobA2

But if I remove the -local optiona and execute it from the bin directory it works...as below

dsjob -run -wait -warn 0 -param SRCE_SYS_NM="I P" <ProjName> JobA2

does a job without any parameters work correctly in UNIX. If not the reason might be else.