Neoview SQL Reference Manual (R2.4 SP2)

1 Introduction
The Neoview SQL database software allows you to use SQL statements, which comply closely
to ANSI SQL:1999, to access SQL databases.
This introduction describes:
• “SQL Language”
• “Security”
• “Data Consistency and Access Options”
• “Database Integrity and Locking”
• “Transaction Management”
• “ANSI Compliance and Neoview SQL Extensions”
• “Neoview SQL Error Messages”
Other sections of this manual describe the syntax and semantics of individual statements,
commands, and language elements.
SQL Language
The SQL language consists of statements and other language elements that you can use to access
SQL databases. For descriptions of individual SQL statements and SQL utilities, see Chapter 2
(page 37) and Chapter 3 (page 209).
SQL language elements are part of statements and commands and include data types, expressions,
functions, identifiers, literals, and predicates. For more information, see Chapter 4 (page 223) and
Chapter 5 (page 301). For information on specific functions and expressions, see Chapter 6
(page 325) and Chapter 7 (page 479).
Security
Roles and IDs
The system setup scripts perform initial configuration. The roles that exist initially on the Neoview
platform are:
• MGR — MGR is used to create roles and users within those roles.
• DBA — role.dba is used by Neoview components to signify the DBA role.
• USER — USER is a sample role and has no significance.
In addition to DBA, USER, and MGR, you can configure up to 250 more roles.
Data Consistency and Access Options
Access options for DML statements affect the consistency of the data that your query accesses.
For any DML statement, you specify access options by using the FOR option ACCESS clause
and, for a SELECT statement, by using this same clause, you can also specify access options for
individual tables and views referenced in the FROM clause.
The possible settings for option in a DML statement are:
Specifies that the data accessed by the DML statement
must be from committed rows.
“READ COMMITTED ”
Specifies that the data accessed by the SELECT statement
need not be from committed rows.
“READ UNCOMMITTED ”
SQL Language 25