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

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
5-36
Examples of GIVE SCHEMA
>>give schema userschema1 to "sql.user5";
--- SQL operation complete.

This example transfers the schema and the objects within the schema ownership
to “SQL.USER5” :
>>give schema userschema1 to "sql.user5" cascade;
--- SQL operation complete.
DDL Locks
During GIVE SCHEMA operation, DDL lock is held to prevent any other concurrent
DDL or utility operation being performed on the schema. The lock is released on
successful completion of the GIVE SCHEMA operation.
If the GIVE SCHEMA operation fails unexpectedly, you must run the RECOVER
SCHEMA operation on that schema to recover from the failed GIVE SCHEMA
operation. After successful recovery, the DDL lock will be released.