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

Hewlett-Packard Company—540440-003
i
HP NonStop SQL/MX Reference
Manual
Index Figures Tables
What’s New in This Manual xxxi
Manual Information xxxi
New and Changed Information xxxii
About This Manual xxxv
Audience xxxv
Organization xxxv
Related Documentation xxxvii
Notation Conventions xl
1. Introduction
SQL/MX Language 1-1
MXCI SQL/MX Conversational Interface 1-2
MXCI Session 1-2
Session Attributes 1-3
Entering a Command 1-3
SQL Comments 1-4
Transactions in MXCI 1-5
Query Interruption and Termination in MXCI 1-5
Security
1-5
The Super ID
1-6
Guardian User ID 1-6
Guardian Super ID 1-6
Data Consistency and Access Options 1-7
SQL/MP Considerations 1-7
READ UNCOMMITTED 1-8
READ COMMITTED 1-8
SERIALIZABLE or REPEATABLE READ 1-8
SKIP CONFLICT 1-8
STABLE 1-9
Database Integrity and Locking 1-10
Lock Duration 1-10