SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
ii
1. Introduction
Data Consistency and Access Options 1-9
SQL/MP Considerations 1-9
READ UNCOMMITTED 1-10
READ COMMITTED 1-10
SERIALIZABLE or REPEATABLE READ 1-10
SKIP CONFLICT 1-10
STABLE 1-11
Database Integrity and Locking 1-12
Lock Duration 1-12
Lock Granularity 1-12
Lock Mode 1-13
Lock Holder 1-13
Transaction Management 1-14
Statement Atomicity 1-15
User-Defined and System-Defined Transactions 1-16
Rules for DML Statements 1-17
Effect of AUTOCOMMIT Option 1-17
Concurrency 1-17
Transaction Access Modes 1-23
Transaction Isolation Levels 1-23
Partition Management 1-25
Internationalization 1-25
Using NonStop SQL/MX to Access SQL/MP Databases 1-25
Naming Objects 1-26
Delimiting Reserved Words in Guardian Names 1-27
Selecting or Changing Data 1-28
Accessing Views
1-32
Access Options 1-32
SQL/MP Stored Text 1-32
SQL/MP File Organizations
1-33
Collations
1-33
ANSI Compliance and SQL/MX Extensions 1-34
Default Settings for ANSI Compliance
1-34
ANSI-Compliant Statements
1-34
Statements That Are SQL/MX Extensions
1-35
ANSI-Compliant Functions
1-36
SQL/MX Error Messages 1-37