SQL0204N  "<name>" is an undefined name.

Explanation:

This error is caused by one of the following:

*  The object identified by "<name>" is not defined in the database.
*  The data partition identified by "<name>" is not defined on the
   table.
*  A data type is being used. This error can occur for the following
   reasons:
   *  If "<name>" is qualified, then a data type with this name does not
      exist in the database.
   *  If "<name>" is unqualified, then the user's path does not contain
      the schema to which the desired data type belongs.
   *  The data type does not exist in the database with a create
      timestamp earlier than the time the package was bound (applies to
      static statements).
   *  If the data type is in the UNDER clause of a CREATE TYPE
      statement, the type name may be the same as the type being
      defined, which is not valid.

*  A function is being referenced in one of:
   *  a DROP FUNCTION statement
   *  a COMMENT ON FUNCTION statement
   *  the SOURCE clause of a CREATE FUNCTION statement

      If "<name>" is qualified, then the function does not exist. If
      "<name>" is unqualified, then a function of this name does not
      exist in any schema of the current path.



      Note that a function cannot be sourced on the COALESCE,
      DBPARTITIONNUM, GREATEST, HASHEDVALUE, LEAST, MAX (scalar), MIN
      (scalar), NULLIF, RID, NVL, RAISE_ERROR, TYPE_ID, TYPE_NAME,
      TYPE_SCHEMA, or VALUE built-in functions.

*  The element named "<name>" is used on the right side of the UNDER
   clause in CREATE SECURITY LABEL COMPONENT statement but has not yet
   been defined as being ROOT or being UNDER some other element
*  The security label component element named "<name>" has not yet been
   defined.
*  One of the following scalar functions specified a security policy
   identified by "<name>" which is not defined in the database.
   *  SECLABEL
   *  SECLABEL_TO_CHAR
   *  SECLABEL_BY_NAME

This return code can be generated for any type of database object.

Federated system users: the object identified by "<name>" is not defined
in the database or "<name>" is not a nickname in a DROP NICKNAME
statement.

Some data sources do not provide the appropriate values for "<name>". In
these cases, the message token will have the following format:
"OBJECT:<data source> TABLE/VIEW", indicating that the actual value for
the specified data source is unknown.

The statement cannot be processed.

User response:

Ensure that the object name (including any required qualifiers) is
correctly specified in the SQL statement and it exists. If the name
refers to a data partition, query the catalog table
SYSCAT.DATAPARTITIONS to find the names of all the data partitions for a
table. For missing data type or function in SOURCE clause, it may be
that the object does not exist, OR it may be that the object does exist
in some schema, but the schema is not present in your path.

For the CREATE or ALTER SECURITY LABEL COMPONENT statement, make sure
that each element specified as a reference element value for positioning
the location of a new element value already exists in the security label
component.

For the CREATE SECURITY LABEL COMPONENT statement, make sure that each
element is specified as either ROOT or as the child in an UNDER clause
before specifying it as the parent in an UNDER clause.

For the scalar functions SECLABEL, SECLABEL_TO_CHAR or SECLABEL_BY_NAME,
ensure that a valid security policy was specified for the argument
security-policy-name.

Federated system users: if the statement is DROP NICKNAME, make sure the
object is actually a nickname. The object might not exist in the
federated database or at the data source. Verify the existence of the
federated database objects (if any) and the data source objects (if
any).

sqlcode: -0204

 sqlstate: 42704