SQL/MX 3.2.1 Messages Manual (H06.26+, J06.15+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.2.1 Messages Manual—691121-002
3-84
SQL 1755
Cause. An attempt was made to execute REVOKE CREATE CATALOG or REVOKE
CREATE SCHEMA statement with PUBLIC as one of the entries in the grantee list or
PUBLIC as the only entry in the grantee list.
Effect. The operation fails.
Recovery. Remove PUBLIC from the grantee list and retry the operation.
SQL 1756
Cause. An attempt was made to perform the RECOVER SCHEMA operation after a
successful GIVE SCHEMA operation.
Effect. The operation fails.
Recovery. None.
SQL 1757
Where object-name is either the table name or schema name.
Cause. An attempt was made to perform one of the following operations:

A GIVE TABLE operation on a table that had referential integrity constraints with
other table(s).

A GIVE SCHEMA operation on a schema that had one or more tables with
referential integrity constraints. The referential integrity constraints were on table(s)
in different schemas.
Effect. The operation fails.
Recovery. If the following conditions are met, perform the GIVE SCHEMA CASCADE
operation to change the ownership of the table with referential integrity constraints:

Ownership of all the objects in the schema must be changed.

The table has referential integrity constraints with other table(s) in the same
schema.
1755 Revoke from PUBLIC is not allowed.
1756 No GIVE SCHEMA operation is in progress. There is
nothing to recover.
1757 GIVE TABLE-or-SCHEMA operation cannot be performed
because object object-name has incompatible RI constraints
for this operation.