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

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