Previous Topic: -178 - WITH CHECK OPTION CANNOT BE DROPPED FROM A VIEW DEFINITIONNext Topic: -180 - ROW HELD BY PREVIOUS LOGICAL UNIT OF WORK WAS DELETED


-179 - CONSTRAINT mmmmm nnnnn NOT FOUND

Explanation

During an SQL ALTER TABLE, you attempted to drop a constraint by name, but the constraint was not found in the SIT. In the message text, mmmmm is the schema name (AUTHID) and nnnnn is the constraint name.

The SQLSTATE that equates to this SQL return code is 42704.

User Response

Query the SIT to determine the correct name of the constraint. For information about querying the SIT, see the CA Datacom/DB Database and System Administration Guide.