SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-70
CONSTRNT Table
CONSTRNT Table
The CONSTRNT table is a catalog table that describes the constraints placed on
tables. Table C-8 describes the contents of the CONSTRNT table.
The CONSTRNT table was created in version 1 and has not been modified in
subsequent versions.
Guardian names in the CONSTRNT table are fully qualified. All CHAR and VARCHAR
columns in the table use uppercase characters except for lowercase literals specified
as part of search conditions stored in the CONSTRAINTTEXT column. Search
conditions that include literals that specify the system default multibyte character set
are stored as if you specified the actual character set. (For example, if the system
default multibyte character set is Kanji, the literal N” ...." is stored as _KANJI”....”.)
CONTINUE Statement
CONTINUE is a DDL statement that specifies a COMMIT option for a DDL operation
ready to enter its final phase.
You can execute CONTINUE only after SQL returns warning 1619 (“To continue
processing, please enter a commit or rollback with a CONTINUE statement.”) to
indicate that a DDL operation is ready to enter its final phase. This warning occurs only
if the DDL statement that started the operation specified COMMIT BY REQUEST.
operation-name
is the name of the operation to continue, as specified by the NAME option in the
DDL statement that started the operation.
If you did not specify the NAME option, operation_name is based on the type of
statement that started the operation (ALTER_TABLE, CREATE_INDEX, and so
forth).
Table C-8. The CONSTRNT Table
Column Name Data Type Description
1 TABLENAME* CHAR(34) Name of table that constraint protects
2 CONSTRAINTNAME* CHAR(30) Name of constraint
3 SEQNUMBER SMALLINT
UNSIGNED
Sequence number of constraint on table (for
system use only)
4 CONSTRAINTTEXT VARCHAR
(3000)
Text of search condition defining constraint
* Indicates primary key
{ COMMIT [WORK] options }
CONTINUE operation-name { ROLLBACK [WORK] }