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

Contents
HP NonStop SQL/MX Reference Manual—523725-004
ii
1. Introduction (continued)
1. Introduction (continued)
Lock Granularity 1-9
Lock Mode 1-9
Lock Holder 1-10
Transaction Management 1-11
Statement Atomicity 1-11
User-Defined and System-Defined Transactions 1-13
Rules for DML Statements 1-13
Effect of AUTOCOMMIT Option 1-13
Concurrency 1-14
Transaction Access Modes 1-19
Transaction Isolation Levels 1-20
Partition Management 1-21
Internationalization 1-21
Using NonStop SQL/MX to Access SQL/MP Databases 1-21
Naming Objects 1-23
Delimiting Reserved Words in Guardian Names 1-24
Selecting or Changing Data 1-25
Accessing Views 1-28
Access Options 1-28
SQL/MP Stored Text 1-29
SQL/MP File Organizations 1-30
Collations 1-30
ANSI Compliance and SQL/MX Extensions 1-31
Default Settings for ANSI Compliance 1-31
ANSI-Compliant Statements 1-31
Statements That Are SQL/MX Extensions 1-32
ANSI-Compliant Functions 1-33
SQL/MX Error Messages 1-34
2. SQL/MX Statements
Categories 2-1
Data Definition Language (DDL) Statements 2-1
Data Manipulation Language (DML) Statements 2-3
Transaction Control Statements 2-3
Prepared SQL Statements 2-3
Embedded-Only SQL/MX Statements 2-4
Resource Control and Optimization Statements 2-4
Control Statements 2-4