IBM Support

SQL0440 warning on SQL routine build

News


Abstract

SQL0440 warning on SQL routine build

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
14 January 2020

UID

ibm11167658