NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-46
COMMENTS Table
COMMENTS Table
The COMMENTS table is a catalog table that stores comments and help text for objects
defined in the catalog. Each comment or help text line is a row of the table. The
following table describes the contents of the COMMENTS table.
COMMENTS was created in version 1 and no new columns have been added in
subsequent versions. HC was added to the list of values for column OBJTYPE in
version 2; CP was added in version 300.
Guardian names in the COMMENTS table are fully qualified and use uppercase
characters. Names in the OBJSUBNAME column also use uppercase characters.
COMMIT Option
COMMIT is an option available on some potentially long-running DDL statements that
specifies the start time, the timeout period for lock requests, and the handling of
retryable errors for the final phase of the operation.
COMMIT also includes a ROLLBACK option that directs SQL to cancel changes to the
database and terminate the operation instead of proceeding with the final phase.
COMMIT is also an option on the CONTINUE statement. CONTINUE continues a
DDL operation that specifies COMMIT BY REQUEST and that is ready to enter its
final phase.
The final phase of a DDL operation (called the commit phase) always requires exclusive
locks on the objects involved. Using the COMMIT option to control the start time,
Column Name Data Type Description
1 OBJNAME * CHAR(34) Name of object commented on; for a constraint,
name of table with constraint
2 OBJSUBNAME * CHAR(30) Name of column if object type is CL or HC; name
of constraint if object type is CN; otherwise ""
3 OBJTYPE * CHAR(2) CL if column
CN if constraint
CP if collation
HC if help text for column
IN if index
TA if table
VI if view
4 SEQNUMBER * SMALLINT
UNSIGNED
Line number of portion of this comment
5 COMMENTTEXT VARCHAR
(132)
Line of comment text
* Indicates primary key