-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 a native SQL procedure, the name token might return the following information:

name-of-procedure VERSION version-id

For 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 (sourced).

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.

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