SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
vi
2. SQL/MX Statements
Scope of CONTROL QUERY SHAPE 2-69
Examples of CONTROL QUERY SHAPE 2-69
CONTROL TABLE Statement 2-73
Considerations for CONTROL TABLE 2-76
Scope of CONTROL TABLE 2-76
Relationship to CONTROL QUERY DEFAULT 2-76
Examples of CONTROL TABLE 2-76
CREATE CATALOG Statement 2-77
Syntax Description of CREATE CATALOG 2-77
Considerations for CREATE CATALOG 2-77
Reserved Catalogs 2-77
Authorization and Availability Requirements 2-77
Examples of CREATE CATALOG 2-78
CREATE INDEX Statement 2-79
Syntax Description of CREATE INDEX 2-80
Considerations for CREATE INDEX 2-84
Authorization and Availability Requirements 2-85
Limits on Indexes 2-85
Examples of CREATE INDEX 2-85
CREATE PROCEDURE Statement 2-87
Considerations for CREATE PROCEDURE 2-92
Authorization and Availability Requirements 2-92
Examples of CREATE PROCEDURE 2-92
CREATE SCHEMA Statement 2-95
Syntax Description of CREATE SCHEMA 2-95
Considerations for CREATE SCHEMA 2-97
Duplicate Schema Subvolume
2-97
Reserved Schema Names 2-97
Examples of CREATE SCHEMA 2-98
CREATE SEQUENCE Statement
2-99
Considerations for CREATE SEQUENCE
2-102
Authorization Requirements 2-102
Restrictions
2-102
Reserved Names
2-102
Examples of CREATE SEQUENCE
2-102
CREATE SQLMP ALIAS Statement
2-103
Considerations for CREATE SQLMP ALIAS 2-104
Reserved Alias Names
2-104
Usage Restrictions 2-104