(SQL报错)DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null
(SQL报错)DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: nulldb中执行没问题,java调用执行的时候报错。
百度得答案:
结果集里,不能传参数
Parameter markers can never be used:
* in a statement that is not a prepared statement
* in the fullselect of a CREATE VIEW statement
* in the triggered action of a CREATE TRIGGER statement
* in a query captured by DB2 Query Patroller
The statement cannot be processed.
User Response: Correct the syntax of the statement. If untyped parameter markers are not allowed, use the CAST specification to give the parameter marker a data type.
这是DB2的错误信息中摘出来的。
我觉得是结果集里的“?”出的问题。
页:
[1]