SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-21
DDL Statements
For information about a specific DDL statement, see the entry for that statement.
Only one DDL statement can operate on a given SQL object (or partition of an SQL
object) at a time. An error occurs if you attempt to execute a DDL statement while
another process is executing a DDL statement on the same object. The specific error
depends on the statement involved and the phase of the operation at which the conflict
occurs.
The most common errors that occur when you attempt to execute a DDL statement on
an SQL object while another DDL operation is in progress on the same object:
CREATE COLLATION
Statement
Creates a collation
CREATE
CONSTRAINT
Statement
Creates a constraint
CREATE INDEX
Statement
Creates an index
CREATE TABLE
Statement
Creates a table
CREATE VIEW
Statement
Creates a view
DROP Statement
Drops a catalog, collation, constraint, index, SQL program in a
Guardian file, table, or view
HELP TEXT Statement
Specifies help text for a column of a table or view
UPDATE STATISTICS
Statement
Updates statistics about the contents of a table and its indexes
File-system Errors
12 File in use
40 The operation timed out
73 The table is locked
1057 Unable to access table that is being altered
SQL/MP Errors
1203 Data could not be retrieved from catalog table name
1222 The label of name could not be altered
Statement Description (page 2 of 2)