00E79010

Explanation

Db2 received an SQL CALL statement for a stored procedure. The CALL statement was not accepted because one or more columns of the SYSIBM.SYSROUTINES catalog table for the procedure contains invalid values. The value of the column was valid in a prior release of Db2, but is invalid in this release of Db2.

Possible reasons for this include a LANGUAGE column with value COMPJAVA.

System action

The statement cannot be performed. SQLCODE -471 is returned on the SQL CALL statement with this reason code.

Programmer response

Use ALTER PROCEDURE to correct the invalid column in the SYSIBM.SYSROUTINES catalog table.

To migrate a LANGUAGE COMPJAVA stored procedure to LANGUAGE JAVA, use the following procedure:
  1. Ensure that you have a WLM application environment that has been set up to run LANGUAGE JAVA.
  2. Put the .class file containing the stored procedure code into a directory that is identified in CLASSPATH in the JAVAENV for your LANGUAGE JAVA WLM application environment. Alternatively, you may put the .class file into a Java™ JAR file and invoke the SQLJ.INSTALL_JAR built-in stored procedure.
  3. Issue an ALTER PROCEDURE command against the stored procedure that specifies LANGUAGE JAVA and WLM ENVIRONMENT java applenv.