SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Contents

HP NonStop SQL/MX Reference Manual—640322-001

xxxi

D. Sample Database (continued)

PARTLOC Table D-13

E. Standard SQL and SQL/MX

ANSI SQL Standards E-1

ISO Standards E-2

SQL/MX Compliance E-2

SQL/MX Extensions to Standard SQL E-6

Character Set Support E-7

Index

Figures

Figure D-1. Sample Database Tables D-2

Tables

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

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

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

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

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

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

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

Table 2-3. EXPLAIN Statement Options 2-146

Table 2-4. Fields of OPTIONS 'm' Output 2-147

Table 2-5. Cost Factors of DETAIL_COST column 2-148

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 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-64

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

Table 9-3. Input and Output Parameters for RELATEDNESS 9-126

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

Table 9-5. Two-Character UCS2 Mapping 9-170

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

Table 9-7. Input and Output Parameters for VERSION_INFO 9-177