Neoview SQL Reference Manual (R2.4)

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 the
client-based utility, Neoview Command Interface (NCI). For information on NCI, see the Neoview
Command Interface (NCI) 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.
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
New or Changed InformationChapter
Updated lock escalation limit in “Lock Granularity” (page 29).Chapter 1 (page 27)
• “ALTER TABLE Statement” (page 45) new syntax for sequence
generator and IDENTITY column.
• “CREATE MATERIALIZED VIEW Statement” (page 61) added
syntax for re-initializing a materialized view and text with respect
to materialized view clustering.
• “CREATE TABLE Statement” (page 70):
— “Calculating Row Size” (page 84) updated formula.
— New syntax for IDENTITY column and sequence generator.
— Updated syntax description for MAX TABLE SIZE.
— Updated CREATE VOLATILE TABLE information, added
information about nullable keys and suitable keys.
— Corrected syntax for CREATE [SET]VOLATILE TABLE
• “CREATE VIEW Statement” (page 99)Vertical Partition example
added. Added isolation level information and ORDER BY clause
guidelines from R2.3 SP2.
• The “GET SERVICE Statement” (page 131) provides additional output
columns.
• “GRANT SCHEMA Statement” (page 137) added privileges for safe
support.
• “INSERT Statement” (page 141) new information with regard to
sequence generator and IDENTITY column.
• “MERGE INTO Statement” (page 149)added WHEN MATCHED
THEN DELETE and other minor corrections.
• “REVOKE SCHEMA Statement” (page 158) added privileges for safe
support.
• “SHOWDDL Statement” (page 192) removed the PROCEDURE
option.
• Removed ALTER INDEX, CREATE PROCEDURE, DROP
PROCEDURE, and CALL PROCEDURE statements.
Chapter 2 (page 39)
“MAINTAIN Command” (page 210) added support for multiple tables.Chapter 3 (page 209)
Intended Audience 19