Supplement to the HP Neoview SQL Reference Manual (R2.3 SP2)

Table of Contents
About This Document.........................................................................................................5
Supported Release Version Updates (RVUs)..........................................................................................5
Intended Audience.................................................................................................................................5
New and Changed Information in This Edition.....................................................................................5
Document Organization.........................................................................................................................5
Notation Conventions.............................................................................................................................5
General Syntax Notation...................................................................................................................5
Related Information................................................................................................................................7
Publishing History..................................................................................................................................7
HP Encourages Your Comments............................................................................................................7
1 Volatile Table Enhancements.........................................................................................9
How to Enable the Volatile Table Enhancements...................................................................................9
How Neoview SQL Supports Nullable Keys.........................................................................................9
How Neoview SQL Selects Suitable Keys..............................................................................................9
Volatile Table Examples........................................................................................................................10
Creating Nullable Constraints.........................................................................................................10
Creating a Nullable Primary Keys..................................................................................................10
Examples for Selecting Suitable Keys..............................................................................................11
2 CREATE VIEW Enhancements.....................................................................................13
How to Enable the CREATE VIEW Enhancements..............................................................................13
Isolation Level Guidelines....................................................................................................................13
Isolation Level Syntax......................................................................................................................13
Single Table in a View......................................................................................................................13
Multiple Tables in a View................................................................................................................13
Explicit User-Specified Isolation Level on SELECT From a View...................................................14
Nested View Definitions..................................................................................................................14
ORDER BY Clause Guidelines..............................................................................................................14
ORDER BY Syntax...........................................................................................................................14
When to Use ORDER BY.................................................................................................................14
ORDER BY in a View Definition With No Override.......................................................................15
ORDER BY in a View Definition With User Override....................................................................15
Nested View Definitions..................................................................................................................15
3 SQL Functions...............................................................................................................17
TIMESTAMPADD Function..................................................................................................................17
Examples of TIMESTAMPADD.......................................................................................................17
TIMESTAMPDIFF Function..................................................................................................................18
Examples of TIMESTAMPDIFF.......................................................................................................18
Required Customer Actions............................................................................................................18
Index.................................................................................................................................21
Table of Contents 3