SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Contents
HP NonStop SQL/MX Reference Manual—640322-001
iv
2. SQL/MX Statements (continued)
2. SQL/MX Statements (continued)
Considerations for CONTROL QUERY SHAPE 2-43
Examples of CONTROL QUERY SHAPE 2-43
CONTROL TABLE Statement 2-48
Considerations for CONTROL TABLE 2-51
Examples of CONTROL TABLE 2-51
CREATE CATALOG Statement 2-52
Syntax Description of CREATE CATALOG 2-52
Considerations for CREATE CATALOG 2-52
Examples of CREATE CATALOG 2-53
CREATE INDEX Statement 2-54
Syntax Description of CREATE INDEX 2-55
Considerations for CREATE INDEX 2-59
Examples of CREATE INDEX 2-60
CREATE PROCEDURE Statement 2-61
Considerations for CREATE PROCEDURE 2-66
Examples of CREATE PROCEDURE 2-67
CREATE SCHEMA Statement 2-69
Syntax Description of CREATE SCHEMA 2-69
Considerations for CREATE SCHEMA 2-71
Examples of CREATE SCHEMA 2-71
CREATE SQLMP ALIAS Statement 2-73
Considerations for CREATE SQLMP ALIAS 2-74
Examples of CREATE SQLMP ALIAS 2-76
CREATE TABLE Statement 2-77
Syntax Description of CREATE TABLE 2-79
Considerations for CREATE TABLE 2-91
Examples of CREATE TABLE 2-98
CREATE TRIGGER Statement 2-101
Syntax Description of CREATE TRIGGER 2-102
Considerations for CREATE TRIGGER 2-104
Examples of CREATE TRIGGER 2-108
CREATE VIEW Statement 2-111
Syntax Description of CREATE VIEW 2-112
Considerations for CREATE VIEW 2-114
Examples of CREATE VIEW 2-115
DELETE Statement 2-116
Considerations for DELETE 2-119
MXCI Examples of DELETE 2-121