Neoview SQL Reference Manual (R2.5)

About This Document
This manual describes reference information about the syntax of SQL statements, functions, and
other SQL language elements supported by the Neoview database software.
The Neoview SQL statements and utilities are entered interactively or from script files using one
of these client-based utilities:
• The Neoview Command Interface (NCI). For information about NCI, see the Neoview
Command Interface (NCI) Guide.
• The HP Database Manager. For information about HPDM, see the HP Database Manager
(HPDM) User Guide.
NOTE: In this manual, SQL language elements, statements, and clauses within statements are
based on the ANSI SQL:1999 standard.
Intended Audience
This manual is intended for database administrators and application programmers who are using
SQL to manage a database on an HP Neoview data warehousing platform.
You 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 version of the manual provides the following new and changed information:
• New persistent sample tables. See “UPDATE STATISTICS Statement” (page 204).
• New command for bulk replication. See “REPLICATE Command” (page 224) .
• New information regarding DISK POOL clause in the CREATE TABLE statement. See
“Considerations for DISK POOL” (page 92).
• New NO LOAD option in the CREATE TABLE statement. See “CREATE TABLE Statement”
(page 72)
• Added STORE BY clause. See “CREATE TABLE Statement” (page 72).
• Added SYSKEY information. See “SYSKEY” (page 272).
• Added new considerations for Extended Numeric Precision data type. See “Extended
Numeric Precision” (page 246).
• From R2.4 SP1:
— Added MAINTAIN command OVERRIDE option. See “MAINTAIN Command”
(page 212).
— Added extended support for delimited identifiers. See “Delimited Identifiers” (page 269).
— Added ANSI holdable cursor support. See “Cursors” (page 239).
• From R2.4 SP2:
— Added how to obtain EXPLAIN plans while queries are running. See “EXPLAIN
Statement” (page 124) and “EXPLAIN Function” (page 401).
Document Organization
• Chapter 1: “Introduction” (page 25), introduces Neoview SQL and covers topics such as
database security, data consistency and integrity, transaction management, and ANSI
compliance.
• Chapter 2: “SQL Statements” (page 37), describes the SQL statements supported by Neoview
SQL.
Intended Audience 19