Neoview SQL Reference Manual (R2.3)

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.
Supported Release Version Updates (RVUs)
HP Neoview Release 2.3.
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
Changed the maximum precision of the numeric data type.“Numeric Data Types ” (page 215)
New section that documents the On Line Analytical Processing (OLAP)
functions.
“OLAP Functions” (page 447)
Added new bit function, BITAND.“BITAND Function” (page 304)
CREATE SET TABLE added to CREATE TABLE description.“CREATE TABLE Statement” (page 69)
Added the MULTI COMMIT option in support of long running updates.“DELETE Statement” (page 91)
Added the RESTRICT | CASCADE options.“DROP INDEX Statement” (page 95)
Added the RESTRICT | CASCADE options.“DROP SCHEMA Statement” (page 98)
Added the RESTRICT | CASCADE options.“DROP TABLE Statement” (page 100)
Added the RESTRICT | CASCADE options.“DROP VIEW Statement” (page 102)
New statement.“GET SERVICE Statement” (page 117)
Added DDL schema privileges.“GRANT SCHEMA Statement” (page 122)
Added UPDATE STATISTICS ALL MVS to the maintain-task option.
“MAINTAIN Command” (page 192)
Added DDL schema privileges. CASCADE drop-behavior is now
supported.
“REVOKE SCHEMA Statement” (page 141)
Added consideration about performance.“Considerations for SELECT” (page 154)
New statement.“SET SERVICE Statement” (page 167)
Added the AUTOBEGIN and MULTI COMMIT options.“SET TRANSACTION Statement” (page 170)
New statement.“SHOWDDL Statement” (page 175)
Added consideration about performance.“Considerations for UPDATE” (page 181)
Added the keyword NECESSARY.“UPDATE STATISTICS Statement”
(page 185)
Updated the privileges description for schemas.“Privileges” (page 255)
Supported Release Version Updates (RVUs) 23