Neoview SQL Reference Manual (R2.5)
• Chapter 3: “SQL Utilities” (page 211), describes utilities that perform tasks such as
maintenance, populating indexes, purging data from tables and indexes, and replicating
schemas, data, and statistics.
• Chapter 4: “SQL Language Elements” (page 233), 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: “SQL Clauses” (page 313), describes clauses used by Neoview SQL statements.
• Chapter 6: “SQL Functions and Expressions” (page 337), describes specific functions and
expressions that you can use in Neoview SQL statements.
• Chapter 7: “OLAP Functions” (page 491), describes specific on line analytical processing
functions.
• Appendix A: “Mapping Tables” (page 509), lists mappings for the UCS2 character set.
• Appendix B: “Reserved Words” (page 519), lists the words that are reserved in Neoview
SQL.
• Appendix C: “Limits” (page 523), describes limits in Neoview SQL.
• Appendix D: “Standard SQL and Neoview SQL” (page 525), describes how Neoview SQL
conforms to the ANSI standard.
• Appendix E: “ Special Neoview Features—Enabled Upon Request” (page 531), provides
information about special Neoview features including Mode_special_2 and its use.
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
20