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.