SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Hewlett-Packard Company—640322-001
i
HP NonStop SQL/MX Reference
Manual
Index Figures Tables
Legal Notices
What’s New in This Manual xxxiii
Manual Information xxxiii
New and Changed Information xxxiv
About This Manual xxxix
Audience xxxix
Organization xxxix
Related Documentation xli
Notation Conventions xliv
HP Encourages Your Comments xlvii
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