Why am I getting a syntax error when calling my stored procedure?

Question

I am trying to call a stored procedure with Time variable as in parameter. But whenever i try to call the procedure i m getting error as:

db2 'call PASS_FAIL_CHECKDATE('2014-01-21','13:42:25','CSS1',Null,'4500096651','10',Null)'
SQL0104N  An unexpected token ":42" was found following "CKDATE(2014-01-21,
13".  Expected tokens may include:  "+".  SQLSTATE=42601

My Procedures input parameter are :

PASS_fail_checkdate (in post_date date,in post_time time,in destplant varchar(4), in destloc varchar(4), in transnum varchar(10), in translineitemnum varchar(6), in inboundconsignment varchar(35))

I am not sure if my declaration for time variable is correct in procedure or if i am calling the time variable correctly in the procedure.

Please give me suggestions on the same.

Suggestion: use double quotation marks around the `CALL` statement. — mustaccio, Aug 31 '16 at 11:44
Try mustaccio's suggestions. He is usually right. In the unlikely event that this doesn't fix your problem, try the iso format for a time '13.42.25'. Good luck and report the results back. — Peter Schuetze, Sep 02 '16 at 20:49

score 0 · Answer 1 · answered Sep 25 '16 at 08:10

As already offered, in words, try the following example as a revision to what was noted in the OP as tried already but failing; i.e. change to use double-quote vs the apostrophe, specified as the delimiter for the DB2 SQL statement string:

db2 "call PASS_FAIL_CHECKDATE('2014-01-21','13:42:25','CSS1',Null,'4500096651','10',Null)"

Why am I getting a syntax error when calling my stored procedure?

1 Answers1