News
Abstract
SQL0440 warning on SQL routine build
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > SQL0440 warning on SQL routine build
When a LANGUAGE SQL procedure includes an “incorrectly coded” static CALL statement, the build succeeds but returns a warning.
Either review the joblog or use the STRDBMON FTRSQLCODE(440) prefiltering support to identify possible miscodings.
- SQLCODE = SQL0440 (+440)
- SQLSTATE = ‘0168L’
Example: Consider the following two CREATE PROCEDURE statements
CREATE PROCEDURE Proc1 (INOUT parm1 varchar(255))
LANGUAGE SQL PROGRAM TYPE SUB
BEGIN RETURN 0; END;
CREATE PROCEDURE Proc2 ()
LANGUAGE SQL PROGRAM TYPE SUB
BEGIN
CALL Proc1(); /* incorrect number of parameters? */
END;
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
14 January 2020
UID
ibm11167658