SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Contents

HP NonStop SQL/MX Reference Manual—523725-004

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 5-1. SQL/MX import Utility 5-31

Figure D-1. Sample Database Tables D-2

Tables

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

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

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

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

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

Table 3-1. GET DESCRIPTOR Items 3-49

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

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

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

Table 3-5.

SET DESCRIPTOR Descriptor Area Items 3-81

Table 6-1.

Construction of the Clustering Key 6-58

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

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

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

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

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

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