Neoview SQL Reference Manual (R2.2)

New or Changed InformationSection
Updated to include ONLINE | OFFLINE options.“POPULATE INDEX Utility” (page 186)
Updated to include schemas.“REVOKE Statement” (page 134)
New statement.“REVOKE EXECUTE Statement” (page 136)
New statement.“REVOKE SCHEMA Statement” (page 138)
New consideration added.“Considerations for SELECT” (page 151)
GROUP BY clause enhanced to allow expressions.
joined-table syntax is extended to support full outer join.
“SELECT Statement” (page 141)
Added table that summarizes the Neoview SQL data types.“Data Types” (page 197)
Extended to allow multiple columns to be specified.
The option NOLOG is changed to NOMVLOG.
“UPDATE Statement” (page 169)
New function.“USER Function” (page 429)
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 181), 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 189), 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 257), describes clauses used by Neoview SQL statements.
• Chapter 6 (page 279), describes specific functions and expressions that you can use in Neoview
SQL statements.
• Appendix A (page 435), is a quick reference to commands, statements, and utilities.
• Appendix B (page 437), lists the words that are reserved in Neoview SQL.
• Appendix C (page 441), describes limits in Neoview SQL.
• Appendix D (page 443), 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:
24 About This Document