Neoview SQL Reference Manual (R2.3)

1 Introduction
The Neoview SQL database software allows you to use SQL DML 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, commands, and other language elements that you can
use to access SQL databases. For descriptions of individual SQL statements, see Chapter 2
(page 41).
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 199).
For information on specific functions and expressions, see Chapter 6 (page 289).
Security
The services ID is intended to be used only to support the database without having access to the
data itself. The services ID cannot manage user accounts. Only HP support has access to the
super ID.
User IDs and Role
The system setup scripts perform initial configuration of services IDs. 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 a valid user ID, enclosed in double quotes. A user ID number (for example, '255,255') is
not allowed. 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.
SQL Language 29