SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
iv
2. SQL/MX Statements
COMMIT WORK Statement 2-49
Considerations for COMMIT WORK 2-49
MXCI Examples of COMMIT WORK 2-49
C Examples of COMMIT WORK 2-50
COBOL Examples of COMMIT WORK 2-51
CONTROL QUERY DEFAULT Statement 2-52
Considerations for CONTROL QUERY DEFAULT 2-52
Examples of CONTROL QUERY DEFAULT 2-53
CONTROL QUERY SHAPE Statement 2-54
Considerations for CONTROL QUERY SHAPE 2-61
Examples of CONTROL QUERY SHAPE 2-61
CONTROL TABLE Statement 2-66
Considerations for CONTROL TABLE 2-69
Examples of CONTROL TABLE 2-69
CREATE CATALOG Statement 2-70
Syntax Description of CREATE CATALOG 2-70
Considerations for CREATE CATALOG 2-70
Examples of CREATE CATALOG 2-71
CREATE INDEX Statement 2-72
Syntax Description of CREATE INDEX 2-73
Considerations for CREATE INDEX 2-77
Examples of CREATE INDEX 2-78
CREATE PROCEDURE Statement 2-80
Considerations for CREATE PROCEDURE 2-85
Examples of CREATE PROCEDURE 2-85
CREATE SCHEMA Statement 2-88
Syntax Description of CREATE SCHEMA
2-88
Considerations for CREATE SCHEMA 2-90
Examples of CREATE SCHEMA 2-91
CREATE SQLMP ALIAS Statement
2-92
Considerations for CREATE SQLMP ALIAS
2-93
Examples of CREATE SQLMP ALIAS 2-94
CREATE TABLE Statement
2-95
Syntax Description of CREATE TABLE
2-99
Considerations for CREATE TABLE
2-112
Examples of CREATE TABLE
2-125
CREATE TRIGGER Statement 2-132
Syntax Description of CREATE TRIGGER
2-133
Considerations for CREATE TRIGGER 2-134