SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Hewlett-Packard Company—544517-008
i
HP NonStop SQL/MX Reference
Manual
Glossary Index Figures Tables
Legal Notices
What’s New in This Manual xxxi
Manual Information xxxi
New and Changed Information xxxii
About This Manual xxxvii
Audience xxxvii
Organization xxxvii
Related Documentation xxxix
Notation Conventions xlii
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