■ 正确代码 Tomcat context.xml中追加currentFunctionPath。 <Resource name="jdbc/testDS" auth="Container" type="javax.sql.DataSource" driverClassName="com.ibm.db2.jcc.DB2Driver" url="jdbc:db2://127.0.0.1:50000/test:currentSchema=QUOTATION;currentFunctionPath=QUOTATION;" username="db2inst1" passwo...
An attempt was made to invoke a routine, but Db2 could not resolve the invocation of a routine, including the argument list, to a specific routine definition. routine-type The type of routine, such as FUNCTION or PROCEDURE. routine-name or schema-name.routine-name The name of the routine....
System action A valid plan or package will be created if no errors are detected. The statement is bound dynamically on each execution of the statement. Programmer response Fix the problem and retry. Change the SQL statement, add new routines, or change the user's SQL path. ...
不过，值得庆幸的是，已经有人帮咱们整理出一份关于 DB2 的错误代码大全啦，以后再遇到数据库报错，直接...
调用存储过程时必须指定Schema,否则Error。 ■ 错误代码 存储过程 SETSCHEMA="QUOT";SETCURRENTPATH="SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","DB2INST1";CREATEPROCEDURECOPY_TABLES (。。。)BEGIN。。。END;GRANTEXECUTEONPROCEDURE"QUOT"."COPY_TABLES"(INTEGER,TIMESTAMP,INTEGER,INTEGER)TOUSER"DB2INST1"WITH...
SQLCODE -440 (不正确的参数)验证命令元素是否与包架构匹配。 SQLCODE -501 (游标未打开)验证命令是否包含 CALL STATIC。 SQLCODE -551 (权限不足)验证是否已设置 CREATE、BIND 和 EXECUTE 包的权限。 SQLCODE -601 (对象名称不唯一)验证命名约定的唯一性。
第一种:去IBM DB2 Infocenter(http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp)去搜索 第二种:直接在db2的命令行下输入:db2 ? SQL30081N [Error Code: -440, SQL State: 42884] DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, ...
SQL0440 SQLCODE -440 SQLSTATE 42884 SQL0440 SQLCODE -440 SQLSTATE 42884 Explanation: Number of arguments on CALL must match procedure. 说明:在调用参数的数量必须符合程序。 SQL0441 SQLCODE -441 SQLSTATE 42601 SQL0441 SQLCODE -441 SQLSTATE 42601 ...
SQLCODE=-302, SQLSTATE=22001 SQLCODE=-420, SQLSTATE=22018 SQLCODE=-421, SQLSTATE=42826 SQLCODE=-433, SQLSTATE=22001 SQLCODE=-440, SQLSTATE=42884 SQLCODE=-551, SQLSTATE=42501 SQLCODE=-668, SQLSTATE=57016 SQLCODE=-670, SQLSTATE=54010 ...
SQLCODE: -440 The SQLSTATE value indicates that no routine was found with the specified name and compatible arguments. Note This problem can also occur when you use any of the DB2 providers that are included with Microsoft...