Neoview SQL Reference Manual (R2.4 SP2)

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.
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 version of the manual provides the following:
• Syntax corrections to the CREATE MATERIALIZED VIEW, CREATE VIEW, and SELECT
statements
• New VALUES statement
• New TABLE statement
Document Organization
• Chapter 1 (page 25), introduces Neoview SQL and covers topics such as database security,
data consistency and integrity, transaction management, and ANSI compliance.
• Chapter 2 (page 37), describes the SQL statements supported by Neoview SQL.
• Chapter 3 (page 209), describes utilities that perform tasks such as maintenance, populating
indexes, purging data from tables and indexes, and reorganizing and reloading data in a
table or index.
• Chapter 4 (page 223), describes parts of the language, such as database objects, data types,
expressions, identifiers, literals, and predicates, which occur within the syntax of Neoview
SQL statements.
• Chapter 5 (page 301), describes clauses used by Neoview SQL statements.
• Chapter 6 (page 325), describes specific functions and expressions that you can use in Neoview
SQL statements.
• Chapter 7 (page 479), describes specific on line analytical processing functions.
• Appendix A (page 497), lists mappings for the UCS2 character set.
• Appendix B (page 507), lists the words that are reserved in Neoview SQL.
• Appendix C (page 511), describes limits in Neoview SQL.
• Appendix D (page 513), describes how Neoview SQL conforms to the ANSI standard.
• Appendix E (page 519), provides information about special Neoview features including
Mode_special_2 and its use.
Intended Audience 19