DB2 SQL-Error: -470
SQLState: 39004
Short Description: SQL CALL STATEMENT SPECIFIED A NULL VALUE FOR INPUT PARAMETER BUT THE STORED PROCEDURE DOES NOT SUPPORT NULL VALUES
DB2 received an SQL CALL statement for a stored procedure and found a null value in the incoming parameter list. The stored procedure was defined in the SYSIBM.SYSROUTINES catalog table with PARAMETER_STYLE of GENERAL, which specifies that the routine does not accept null values. A call to a stored procedure with a LANGUAGE value of JAVA receives this SQLCODE if an input parameter in the compiled Java stored procedure has a Java base type that cannot be set to a null value. number The parameter number from the ORDINAL field in SYSIBM.SYSPARMS.System action: The statement cannot be executed. Programmer response: If the stored procedure should not accept null values, change the calling application to provide a non-null value. If the stored procedure should accept null values, use the ALTER PROCEDURE statement to change the PARAMETER STYLE of the stored procedure to be DB2SQL or GENERAL WITH NULLS.