SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
3-82
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.
There are no tables having referential integrity constraints with tables in other
schema(s).
SQL 1758
Where object-type is either Table or View.
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.
1758 Request failed. Operation cannot be performed because
targeted new owner does not have sufficient privileges on
object-type object-name.