Neoview SQL Reference Manual (R2.4)

Table of Contents
About This Document.......................................................................................................19
Intended Audience................................................................................................................................19
New and Changed Information in This Edition...................................................................................19
Document Organization.......................................................................................................................21
Notation Conventions...........................................................................................................................21
General Syntax Notation.................................................................................................................21
Related Documentation........................................................................................................................23
Neoview Customer Library.............................................................................................................23
Publishing History................................................................................................................................25
HP Encourages Your Comments..........................................................................................................25
1 Introduction...................................................................................................................27
SQL Language.......................................................................................................................................27
Security.................................................................................................................................................27
User IDs and Role............................................................................................................................27
Authorization ID.............................................................................................................................27
Data Consistency and Access Options..................................................................................................27
READ UNCOMMITTED ................................................................................................................28
READ COMMITTED ......................................................................................................................28
SERIALIZABLE or REPEATABLE READ.......................................................................................28
SKIP CONFLICT..............................................................................................................................29
Database Integrity and Locking............................................................................................................29
Lock Duration..................................................................................................................................29
Lock Granularity..............................................................................................................................29
Lock Mode.......................................................................................................................................29
Lock Holder.....................................................................................................................................30
Transaction Management......................................................................................................................30
Statement Atomicity........................................................................................................................30
User-Defined and System-Defined Transactions............................................................................31
Rules for DML Statements...............................................................................................................31
Effect of AUTOCOMMIT Option....................................................................................................31
Concurrency....................................................................................................................................31
Transaction Access Modes...............................................................................................................33
Transaction Isolation Levels............................................................................................................34
Transaction Rollback Mode.............................................................................................................35
ANSI Compliance and Neoview SQL Extensions................................................................................35
ANSI-Compliant Statements...........................................................................................................35
Statements That Are Neoview SQL Extensions..............................................................................36
ANSI-Compliant Functions.............................................................................................................36
Neoview SQL Error Messages..............................................................................................................37
2 SQL Statements.............................................................................................................39
Categories.............................................................................................................................................39
Data Definition Language (DDL) Statements.................................................................................39
Data Manipulation Language (DML) Statements...........................................................................40
Transaction Control Statements.......................................................................................................40
Resource Control and Optimization Statements.............................................................................40
Control Statements..........................................................................................................................41
Object Naming Statements..............................................................................................................41
Table of Contents 3