-079   QUALIFIER FOR OBJECT name WAS SPECIFIED AS qualifier1 but qualifier2 IS REQUIRED

Explanation

The schema qualifier for the DB2® object must be qualifier2. The statement defines a new object named name with an explicit schema qualifier of qualifier1. Specifying a schema qualifier other than qualifier2 is not allowed.

System action

The statement cannot be processed.

Programmer response

Change the statement in one of the following ways:

  • Change the schema qualifier to qualifier2.
  • Remove the schema qualifier, and let DB2 default it to qualifier2.

SQLSTATE

428EK