-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