-204 name IS AN UNDEFINED NAME
Explanation
The object that is identified by name is not defined in the Db2 subsystem. This SQLCODE can be generated for any type of Db2 object.
If the error was encountered for a particular version of an object, the name token might return the version identifier. For example:
name-of-procedure VERSION version-idFor COMMENT or DROP, if the specified object is a package, the implicitly or explicitly specified version of the package is not defined in the Db2 subsystem. If the version-ID was not explicitly specified, the statement attempted to process the null version for the identified package, but the null version does not exist. The VERSION clause can be used to specify a specific version to be processed.
For CREATE FUNCTION, the name token can refer to a built-in function that cannot be the source of a user-defined function, or cannot be used as the source of a user-defined function in certain conditions. For details, see CREATE FUNCTION statement (sourced function).
If the statement executes on an accelerator, the name token can refer the name of a table on the accelerator server instead of the name of the associated table on Db2.
System action
The statement cannot be processed.
Programmer response
Verify that the object name was correctly specified in the SQL statement, including any required qualifiers. If it is correct, ensure that the object exists in the system before resubmitting the statement.
Check the application compatibility value that is used by your application to ensure that it is set properly. The behavior of the statement might change based on the application compatibility level.
If the specified object is a routine, issue the CREATE PROCEDURE or CREATE FUNCTION statement to define the routine to Db2. Issue the -START PROCEDURE command to activate the new definition.
If the specified object is a package, issue the COMMENT or DROP statement with the VERSION clause to identify the specific version to be processed.
SQLSTATE
42704, 46002