SQL/MX 2.x Reference Manual (H06.04+)

Contents
HP NonStop SQL/MX Reference Manual—540440-003
ii
1. Introduction (continued)
1. Introduction (continued)
Lock Granularity 1-10
Lock Mode 1-11
Lock Holder 1-11
Transaction Management 1-12
Statement Atomicity 1-13
User-Defined and System-Defined Transactions 1-14
Rules for DML Statements 1-15
Effect of AUTOCOMMIT Option 1-15
Concurrency 1-15
Transaction Access Modes 1-21
Transaction Isolation Levels 1-21
Partition Management 1-23
Internationalization 1-23
Using NonStop SQL/MX to Access SQL/MP Databases 1-23
Naming Objects 1-24
Delimiting Reserved Words in Guardian Names 1-26
Selecting or Changing Data 1-26
Accessing Views 1-30
Access Options 1-30
SQL/MP Stored Text 1-30
SQL/MP File Organizations 1-31
Collations 1-31
ANSI Compliance and SQL/MX Extensions 1-32
Default Settings for ANSI Compliance 1-32
ANSI-Compliant Statements 1-32
Statements That Are SQL/MX Extensions 1-33
ANSI-Compliant Functions 1-34
SQL/MX Error Messages 1-35
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