SQL/MX 2.x Reference Manual (H06.04+)

Contents
HP NonStop SQL/MX Reference Manual—540440-003
iv
2. SQL/MX Statements (continued)
2. SQL/MX Statements (continued)
CONTROL TABLE Statement 2-46
Considerations for CONTROL TABLE 2-49
Examples of CONTROL TABLE 2-49
CREATE CATALOG Statement 2-50
Syntax Description of CREATE CATALOG 2-50
Considerations for CREATE CATALOG 2-50
Examples of CREATE CATALOG 2-51
CREATE INDEX Statement 2-52
Syntax Description of CREATE INDEX 2-53
Considerations for CREATE INDEX 2-57
Examples of CREATE INDEX 2-58
CREATE PROCEDURE Statement 2-59
Considerations for CREATE PROCEDURE 2-64
Examples of CREATE PROCEDURE 2-64
CREATE SCHEMA Statement 2-66
Syntax Description of CREATE SCHEMA 2-66
Considerations for CREATE SCHEMA 2-68
Examples of CREATE SCHEMA 2-69
CREATE SQLMP ALIAS Statement 2-70
Considerations for CREATE SQLMP ALIAS 2-71
Examples of CREATE SQLMP ALIAS 2-73
CREATE TABLE Statement 2-74
Syntax Description of CREATE TABLE 2-76
Considerations for CREATE TABLE 2-87
Examples of CREATE TABLE 2-91
CREATE TRIGGER Statement 2-95
Syntax Description of CREATE TRIGGER 2-95
Considerations for CREATE TRIGGER 2-97
Examples of CREATE TRIGGER 2-101
CREATE VIEW Statement 2-104
Syntax Description of CREATE VIEW 2-105
Considerations for CREATE VIEW 2-107
Examples of CREATE VIEW 2-108
DELETE Statement 2-109
Considerations for DELETE 2-112
MXCI Examples of DELETE 2-114
C Examples of DELETE 2-115
COBOL Examples of DELETE 2-116