SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Contents

HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001

xxxiii

Index

Figures

Figure D-1. Sample Database Tables D-2

Tables

Table 1-1. Concurrent DDL/Utility Operation and File Access Modes 1-18

Table 1-2. Concurrent DDL/Utility and DML Operations 1-18

Table 1-3. Concurrent DML and DDL Operations 1-19

Table 1-4. Operations Effect on Table Timestamps 1-20

Table 1-5. Concurrency Limits on Utility Operations 1-21

Table 2-1. Maximum Key Sizes Available 2-104

Table 2-2. Maximum Row Sizes Available 2-115

Table 2-3. SG Table for IDENTITY COLUMN 2-118

Table 2-4. EXPLAIN Statement Options 2-184

Table 2-5. Fields of OPTIONS 'm' Output 2-185

Table 2-6. Cost Factors of DETAIL_COST column 2-186

Table 3-1. GET DESCRIPTOR Items 3-48

Table 3-2. Descriptor Area Data Type Declarations 3-51

Table 3-3. GET DIAGNOSTICS Statement Items 3-57

Table 3-4. GET DIAGNOSTICS Condition Items 3-57

Table 3-5. SET DESCRIPTOR Descriptor Area Items 3-80

Table 5-1. Rules for copying SG Table data 5-23

Table 6-1. Construction of the Clustering Key 6-60

Table 6-2. Clustering Key for Indexes 6-61

Table 9-1.

Input and Output Parameters for FEATURE_VERSION_INFO 9-76

Table 9-2. One-to-One Uppercase and Titlecase to Lowercase Mappings 9-94

Table 9-3.

Input and Output Parameters for RELATEDNESS 9-144

Table 9-4. One-to-One UCS2 Mappings 9-194

Table 9-5.

Two-Character UCS2 Mapping 9-197

Table 9-6. Three-Character UCS2 Mapping 9-199

Table 9-7.

Input and Output Parameters for VERSION_INFO 9-204

Table 9-8.

Values for the E_TYPE and E_VALUE Parameters 9-205

Table 9-9. VERSION Output Column Values E_TYPE and E_VALUE

Parameters 9-205

Table B-1.

Reserved SQL/MX and SQL/MP Identifiers B-1