Neoview SQL Reference Manual (R2.3)

Drops a view.“DROP VIEW Statement” (page 102)
Grants access privileges for a table or view to specified
roles.
“GRANT Statement” (page 118)
Grants privileges for executing a stored procedure in Java
(SPJ) to specified roles.
“GRANT EXECUTE Statement” (page 120)
Grants access privileges for a schema to specified roles.“GRANT SCHEMA Statement” (page 122)
Revokes access privileges for a table or view from specified
roles.
“REVOKE Statement” (page 137)
Revokes privileges for executing a stored procedure from
specified roles.
“REVOKE EXECUTE Statement” (page 139)
Data Manipulation Language (DML) Statements
Use these DML statements to delete, insert, select, or update rows in one or more tables:
Deletes rows from a table or view.“DELETE Statement” (page 91)
Inserts data into tables and views.“INSERT Statement” (page 124)
Retrieves data from tables and views.“SELECT Statement” (page 144)
Updates values in columns of a table or view.“UPDATE Statement” (page 179)
For information about DELETE, INSERT, SELECT, and UPDATE, see individual entries for these
statements.
Transaction Control Statements
Use these statements to specify user-defined transactions and to set attributes for the next
transaction:
Starts a transaction.“BEGIN WORK Statement” (page 52)
Commits changes made during a transaction and ends the
transaction.
“COMMIT WORK Statement” (page 56)
Performs all table maintenance operations.“MERGE INTO Statement” (page 132)
Undoes changes made during a transaction and ends the
transaction.
“ROLLBACK WORK Statement” (page 143)
Sets attributes for the next SQL transaction — the isolation
level, access mode, size of the diagnostics area, and
whether to automatically commit database changes.
“SET TRANSACTION Statement” (page 170)
Resource Control and Optimization Statements
Use these statements to control access to a Neoview SQL table and its indexes on remote segments:
Executes and SQL statement previously compiled by a
PREPARE statement.
“EXECUTE Statement” (page 103)
Locks the specified table (or the underlying tables of a
view) and its associated indexes for the duration of the
active transaction.
“LOCK TABLE Statement” (page 130)
Compiles an SQL statement for later use with the
EXECUTE statement.
“PREPARE Statement” (page 135)
Updates statistics about the contents of a table and its
indexes.
“UPDATE STATISTICS Statement” (page 185)
42 SQL Statements