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

Hewlett-Packard Company—691117-005
i
HP NonStop SQL/MX Release
3.2.1 Reference Manual
Index Figures Tables
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
Case Sensitivity 1-3
Breaking the Command Line 1-3
SQL Comments 1-4
Examples of 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
Security Administrator 1-6
Security Administrator's Group
1-7
With Grant Option 1-7
Owner-Derived Grant
1-7
Derived Privilege 1-7
Derived WGO
1-7
Security Administrator Grant 1-7
Data Consistency and Access Options
1-8
SQL/MP Considerations
1-8
READ UNCOMMITTED 1-9
READ COMMITTED
1-9
SERIALIZABLE or REPEATABLE READ
1-9
SKIP CONFLICT
1-9
STABLE
1-10
Database Integrity and Locking 1-11