Neoview SQL Reference Manual (R2.4 SP2)

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