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

About This Document
This document supplements the Neoview SQL Reference Manual for Neoview Release 2.3 Service
Pack 2. It describes the volatile table and CREATE VIEW enhancements implemented with this
release.
Supported Release Version Updates (RVUs)
HP Neoview Release 2.3 Service Pack 2
Intended Audience
This supplement is intended for database administrators and application programmers who are
using Neoview SQL to manage a database on an HP Neoview data warehousing platform.
The reader should be familiar with structured query language (SQL) and with the American
National Standard Database Language SQL:1999.
New and Changed Information in This Edition
This is a new document.
Document Organization
• Chapter 1 (page 9) describes the volatile table enhancements implemented with Neoview
Release 2.3 Service Pack 2.
• Chapter 2 (page 13) describes the CREATE VIEW enhancements implemented with Neoview
Release 2.3 Service Pack 2.
• Chapter 3 (page 17) describes the new SQL functions TIMESTAMPADD and
TIMESTAMPDIFF.
Notation Conventions
General Syntax Notation
This list summarizes the notation conventions for syntax presentation in this manual.
UPPERCASE LETTERS
Uppercase letters indicate keywords and reserved words. Type these items exactly as shown.
Items not enclosed in brackets are required. For example:
SELECT
Italic Letters
Italic letters, regardless of font, indicate variable items that you supply. Items not enclosed
in brackets are required. For example:
file-name
Computer Type
Computer type letters within text indicate case-sensitive keywords and reserved words. Type
these items exactly as shown. Items not enclosed in brackets are required. For example:
myfile.sh
Bold Text
Bold text in an example indicates user input typed at the terminal. For example:
ENTER RUN CODE
Supported Release Version Updates (RVUs) 5