SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Contents
HP NonStop SQL/MX Reference Manual—544517-008
iv
2. SQL/MX Statements (continued)
2. SQL/MX Statements (continued)
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-90
Examples of CREATE TABLE 2-97
CREATE TRIGGER Statement 2-100
Syntax Description of CREATE TRIGGER 2-101
Considerations for CREATE TRIGGER 2-103
Examples of CREATE TRIGGER 2-107
CREATE VIEW Statement 2-109
Syntax Description of CREATE VIEW 2-110
Considerations for CREATE VIEW 2-112
Examples of CREATE VIEW 2-113
DELETE Statement 2-114
Considerations for DELETE 2-117
MXCI Examples of DELETE 2-119
C Examples of DELETE 2-120