SQL/MX 2.x Reference Manual (H06.04+)

Contents

HP NonStop SQL/MX Reference Manual—540440-003

xxix

D. Sample Database (continued)

SUPPLIER Table D-10

PARTSUPP Table D-11

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 3-1. GET DESCRIPTOR Items 3-47

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

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

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

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

Table 6-1.

Construction of the Clustering Key 6-56

Table 6-2.

Clustering Key for Indexes 6-57

Table 9-1. One-to-One Uppercase and Titlecase to Lowercase Mappings 9-74

Table 9-2. One-to-One UCS2 Mappings 9-156

Table 9-3. Two-Character UCS2 Mapping 9-159

Table 9-4. Three-Character UCS2 Mapping 9-161

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