Neoview SQL Reference Manual (R2.4)

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, see Chapter 2 (page 39) 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 221).
For information on specific functions and expressions, see Chapter 6 (page 317).
Security
User IDs and Role
The system setup scripts perform initial configuration. The roles that exist initially on the Neoview
platform are:
• MGR
• DBA
• USER
DBA and USER are sample roles and have no significance. You can use them or create your own
roles.
MGR is used to create roles and users within those roles.
In addition to DBA, USER, and MGR, you can configure up to 252 more roles.
Authorization ID
Authorization IDs identify users during the processing of SQL statements. The authorization ID
must be enclosed in double quotes. Authids are case-insensitive.
ANSI SQL specifies two special authorization IDs: PUBLIC and SYSTEM.
• PUBLIC specifies all present and future authorization IDs. A grantor cannot be PUBLIC.
• SYSTEM specifies the implicit grantor of privileges to the creators of objects. You cannot
specify SYSTEM as either a grantee or a grantor.
Data Consistency and Access Options
Access options for DML statements affect the consistency of the data that your query accesses.
SQL Language 27