SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
iv
2. SQL/MX Statements
COMMIT WORK Statement 2-53
Considerations for COMMIT WORK 2-53
MXCI Examples of COMMIT WORK 2-53
C Examples of COMMIT WORK 2-54
COBOL Examples of COMMIT WORK 2-55
CONTROL QUERY DEFAULT Statement 2-56
Considerations for CONTROL QUERY DEFAULT 2-56
Examples of CONTROL QUERY DEFAULT 2-57
CONTROL QUERY SHAPE Statement 2-58
Considerations for CONTROL QUERY SHAPE 2-65
Examples of CONTROL QUERY SHAPE 2-65
CONTROL TABLE Statement 2-70
Considerations for CONTROL TABLE 2-73
Examples of CONTROL TABLE 2-73
CREATE CATALOG Statement 2-74
Syntax Description of CREATE CATALOG 2-74
Considerations for CREATE CATALOG 2-74
Examples of CREATE CATALOG 2-75
CREATE INDEX Statement 2-76
Syntax Description of CREATE INDEX 2-77
Considerations for CREATE INDEX 2-81
Examples of CREATE INDEX 2-82
CREATE PROCEDURE Statement 2-83
Considerations for CREATE PROCEDURE 2-89
Examples of CREATE PROCEDURE 2-89
CREATE SCHEMA Statement 2-92
Syntax Description of CREATE SCHEMA
2-92
Considerations for CREATE SCHEMA 2-94
Examples of CREATE SCHEMA 2-95
CREATE SQLMP ALIAS Statement
2-96
Considerations for CREATE SQLMP ALIAS
2-97
Examples of CREATE SQLMP ALIAS 2-99
CREATE TABLE Statement
2-100
Syntax Description of CREATE TABLE
2-104
Considerations for CREATE TABLE
2-117
Examples of CREATE TABLE
2-130
CREATE TRIGGER Statement 2-140
Syntax Description of CREATE TRIGGER
2-141
Considerations for CREATE TRIGGER 2-143