SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
ii
1. Introduction
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
User-Defined Transactions 1-15
System-Defined Transactions 1-15
Rules for DML Statements 1-16
Audited and Nonaudited Tables 1-16
Effect of AUTOCOMMIT Option 1-16
Concurrency 1-16
Transaction Access Modes 1-23
READ ONLY 1-23
READ WRITE 1-23
Transaction Isolation Levels 1-23
READ UNCOMMITTED 1-23
READ COMMITTED 1-24
SERIALIZABLE or REPEATABLE READ 1-24
Non-Unique Key Considerations for SERIALIZABLE or REPEATABLE
READ 1-24
Partition Management 1-25
Internationalization 1-25
Using NonStop SQL/MX to Access SQL/MP Databases 1-25
Naming Objects 1-26
Physical Names
1-26
Logical Names 1-26
Alias Mappings 1-27
DEFINE Names
1-27
Delimiting Reserved Words in Guardian Names
1-27
Selecting or Changing Data 1-28
DATETIME Data
1-28
INTERVAL Data
1-30
NCHAR Data
1-31
Accessing Views
1-32
Access Options 1-32
SQL/MP Stored Text
1-32
SQL/MP File Organizations
1-33