00E79006

Explanation

Db2 received an SQL CALL statement for a stored procedure or an SQL statement containing an invocation of a user-defined function. The statement cannot be accepted, because the load module for the user-created routine is not compatible with Language Environment® preinitialization environment.

System action

The SQL CALL statement is rejected with SQLCODE -471 and this reason code.

Programmer response

Ensure the routine is compiled with a level of the compiler which generates a module that can be a target of a Language Environment preinitialization CEEPIPI call. Ensure that the routine is link edited with the Language Environment runtime library.

Verify that the user-written routine is described correctly in SYSIBM.SYSROUTINES as a main or sub program. This failure can occur if the procedure options for the stored procedure indicate it is a sub program and the specification in the catalog indicates it is a main program.

Message DSNX962I will also be displayed on the MVS™ system console. This message indicates the specific Language Environment preinitialization service that failed and the failing return code.