dsjob -run -param

dnat · Post by **dnat** » Thu Feb 28, 2008 4:17 am

hi,

i am passing insert , update statements as parameters in a job. When i run it through director, there are no issues. But when i try to run it through command prompt via a dsjob command, it is giving me the following error:-
ksh: 0403-057 Syntax error: `(' is not expected.

my command is like this dsjob -run -param INSER_SQL = INSERT INTO CLIENT(ID) VALUES(ORCHESTRATE.ID)

deanwalker · Post by **deanwalker** » Thu Feb 28, 2008 4:29 am

Quote the whole parameter.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 28, 2008 4:31 am

No spaces around the "=", either.

dnat · Post by **dnat** » Thu Feb 28, 2008 8:18 am

i used quotes and i removed the spaces around the "=". No i am getting this error.

Error -3 getting information for parameter 'INSER_SQL'

Status code = -3 DSJE_BADPARAM

ArndW · Post by **ArndW** » Thu Feb 28, 2008 8:45 am

It looks like your job has no INSER_SQL parameter.