SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
xxxii
E. Standard SQL and SQL/MX
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-17
Table 1-2. Concurrent DDL/Utility and DML Operations 1-17
Table 1-3. Concurrent DML and DDL Operations 1-18
Table 1-4. Operations Effect on Table Timestamps 1-19
Table 1-5. Concurrency Limits on Utility Operations 1-20
Table 2-1. Maximum Key Sizes Available 2-104
Table 2-2. Maximum Row Sizes Available 2-115
Table 2-3. SG Table 2-118
Table 2-4. EXPLAIN Statement Options 2-177
Table 2-5. Fields of OPTIONS 'm' Output 2-178
Table 2-6. Cost Factors of DETAIL_COST column 2-179
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-16
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-71
Table 9-2.
One-to-One Uppercase and Titlecase to Lowercase Mappings 9-89
Table 9-3.
Input and Output Parameters for RELATEDNESS 9-139
Table 9-4.
One-to-One UCS2 Mappings 9-189
Table 9-5. Two-Character UCS2 Mapping 9-192
Table 9-6.
Three-Character UCS2 Mapping 9-194
Table 9-7.
Input and Output Parameters for VERSION_INFO 9-199
Table 9-8. Values for the E_TYPE and E_VALUE Parameters 9-200