DSXchange

Hi,

I am trying to run a job in UNIX. I am using dsjob -run -mode NORMAL -param user=raj password=aaaa ETL Jp_raj
but I am getting an error saying
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

Can you help me out I searched in forumsbut didnt find it.

YOu need the literal -param before each parameter value. You are missing it before the second parameter.

DSguru2B wrote:YOu need the literal -param before each parameter value. You are missing it before the second parameter.

Should we keep inverted commas for the parameter values??

Are you asking if you need to quote them? No, not typically, unless perhaps the parameter value has a space in it.

You dont have to, but you could. In that case make sure you have the entire string after the '-param' in inverted commas. So your command above will become.

Not sure I've ever seen quotes referred to as 'inverted commas' before.

DSguru2B wrote:You dont have to, but you could. In that case make sure you have the entire string after the '-param' in inverted commas. So your command above will become.

Code: Select all

dsjob -run -mode NORMAL -param 'user=raj' -param 'password=aaaa' ETL Jp_raj

thank you for your response, but I am getting an error saying

Error -3 getting information for parameter 'user'

Status code = -3 DSJE_BADPARAM

Do you have these parameters defined in your job, identical parameters?

Must not... note that they must exactly match the parameter name, case and spelling.

chulett wrote:Must not... note that they must exactly match the parameter name, case and spelling.

I copied and pasted then also I am getting the same error

Try without the quotes. If that does not work then post your exact command.

Are these actually job parameters or are you intending to use the -user and -password options to the dsjob command itself?

ray.wurlod wrote:Are these actually job parameters or are you intending to use the -user and -password options to the dsjob command itself? ...

As Ray mentioned, if that is the case then run the command

If that's the case, what it was that they "copied and pasted", I wonder?

My guess is from this thread into their DataStage environment.