NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-65
CONSTRNT Table
also keeps such values from being added to the table because SQL rejects any such
values after the constraint is in place.
A constraint name is an SQL identifier.
See CREATE CONSTRAINT Statement
on page C-131 for more information.
CONSTRNT Table
The CONSTRNT table is a catalog table that describes the constraints placed on tables.
The following table 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.
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] }