I try to call a proc like this...

call proctest(?, ?, 'doit');

The first two args are output params (DATETIME). The last is an input param (VARCHAR).

I get the following error:

Error: com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -313, SQLSTATE: 07004, SQLERRMC: null, SQL State: 07004, Error Code: -313

Do I have to prep the arguments in some way before I make the call?

The -313 may be happening inside the SP. I would look up that error message in the manual and check your SP to make sure it is written properly.

The error is : The USING clause or INTO clause is required for dynamic parameters


I don't have access to the sp code

From the above I'm assuming you make your call from some Java code. It would help if you posted the code fragment where you make the call.

Nope, I am not calling it from Java. I am using Squirrel SQL's SQL Worksheet. I also tried JDeveloper's sql tool and got the same results.

Try it from a DB2 Command Prompt:

db2 connect to <database-name>

db2 "call proctest(?, ?, 'doit')"