SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Contents
HP NonStop SQL/MX Reference Manual—523725-004
iv
2. SQL/MX Statements (continued)
2. SQL/MX Statements (continued)
CONTROL TABLE Statement 2-48
Considerations for CONTROL TABLE 2-50
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-66
CREATE SCHEMA Statement 2-68
Syntax Description of CREATE SCHEMA 2-68
Considerations for CREATE SCHEMA 2-70
Examples of CREATE SCHEMA 2-70
CREATE SQLMP ALIAS Statement 2-71
Considerations for CREATE SQLMP ALIAS 2-71
Examples of CREATE SQLMP ALIAS 2-74
CREATE TABLE Statement 2-75
Syntax Description of CREATE TABLE 2-77
Considerations for CREATE TABLE 2-87
Examples of CREATE TABLE 2-91
CREATE TRIGGER Statement 2-96
Syntax Description of CREATE TRIGGER 2-96
Considerations for CREATE TRIGGER 2-98
Examples of CREATE TRIGGER 2-102
CREATE VIEW Statement 2-105
Syntax Description of CREATE VIEW 2-106
Considerations for CREATE VIEW 2-108
Examples of CREATE VIEW 2-109
DELETE Statement 2-110
Considerations for DELETE 2-113
MXCI Examples of DELETE 2-115
C Examples of DELETE 2-116
COBOL Examples of DELETE 2-117