Neoview SQL Reference Manual (R2.3)
Document Organization
• Chapter 1 (page 29), introduces Neoview SQL and covers topics such as database security,
data consistency and integrity, transaction management, and ANSI compliance.
• Chapter 2 (page 41), describes the SQL statements supported by Neoview SQL.
• Chapter 3 (page 191), 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 199), 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 267), describes clauses used by Neoview SQL statements.
• Chapter 6 (page 289), describes specific functions and expressions that you can use in Neoview
SQL statements.
• Chapter 7 (page 447), describes specific on line analytical processing functions.
• Appendix A (page 457), is a quick reference to commands, statements, and utilities.
• Appendix B (page 459), lists the words that are reserved in Neoview SQL.
• Appendix C (page 463), describes limits in Neoview SQL.
• Appendix D (page 465), describes how Neoview SQL conforms to the ANSI standard.
Notation Conventions
General Syntax Notation
This list summarizes the notation conventions for syntax presentation in this manual.
UPPERCASE LETTERS
Uppercase letters indicate keywords and reserved words. Type these items exactly as shown.
Items not enclosed in brackets are required. For example:
SELECT
Italic Letters
Italic letters, regardless of font, indicate variable items that you supply. Items not enclosed
in brackets are required. For example:
file-name
Computer Type
Computer type letters within text indicate case-sensitive keywords and reserved words. Type
these items exactly as shown. Items not enclosed in brackets are required. For example:
myfile.sh
Bold Text
Bold text in an example indicates user input typed at the terminal. For example:
ENTER RUN CODE
?123
CODE RECEIVED: 123.00
The user must press the Return key after typing the input.
[ ] Brackets
Brackets enclose optional syntax items. For example:
DATETIME [start-field TO] end-field
24