Neoview SQL Reference Manual (R2.2)

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 Script. For information on Neoview Script, see the Neoview Script
Guide.
NOTE: In this manual, SQL language elements, statements, and clauses within statements are
based on the ANSI SQL:1999 standard.
Supported Release Version Updates (RVUs)
HP Neoview Release 2.2.
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 InformationSection
Updated considerations.“ALTER MATERIALIZED VIEW
Statement” (page 44)
Added Considerations subsection for ALTER MVGROUP.“ALTER MVGROUP Statement” (page 45)
New statement.“CALL Statement” (page 53)
Updated syntax.“CREATE MATERIALIZED VIEW
Statement” (page 60)
Added DISK POOL and ALIGNED | PACKED format to the list of
attributes.
“CREATE TABLE Statement” (page 69)
New function.“CURRENT_ROLE Function” (page 314)
New function.“CURRENT_USER Function” (page 317)
The option NOLOG is changed to NOMVLOG.“DELETE Statement” (page 90)
Added Considerations subsection for DROP MVGROUP.“DROP MVGROUP Statement” (page 95)
New function.“EXPLAIN Function” (page 339)
New statement.“EXPLAIN Statement” (page 104)
Corrected syntax.“GRANT Statement” (page 115)
New statement.“GRANT EXECUTE Statement” (page 117)
New statement.“GRANT SCHEMA Statement” (page 119)
The option NOLOG is changed to NOMVLOG.
Deleted some considerations.
Added a consideration on self-referencing INSERT.
“INSERT Statement” (page 121)
The keyword LOG is changed to MVLOG.“MAINTAIN MVGROUP” (page 184)
New statement.“MERGE INTO Statement” (page 129)
Updated to include information on schemas.“Privileges” (page 245)
Supported Release Version Updates (RVUs) 23