DSXchange

Posted: **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)

Posted: **Thu Feb 28, 2008 4:29 am**

Quote the whole parameter.

Posted: **Thu Feb 28, 2008 4:31 am**

No spaces around the "=", either.

Posted: **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

Posted: **Thu Feb 28, 2008 8:45 am**

It looks like your job has no INSER_SQL parameter.