Neoview SQL Reference Manual (R2.2)

Drops a view.“DROP VIEW Statement” (page 100)
Grants access privileges for a table or view to specified
roles.
“GRANT Statement” (page 115)
Grants privileges for executing a stored procedure in Java
(SPJ) to specified roles.
“GRANT EXECUTE Statement” (page 117)
Grants access privileges for a schema to specified roles.“GRANT SCHEMA Statement” (page 119)
Revokes access privileges for a table or view from specified
roles.
“REVOKE Statement” (page 134)
Revokes privileges for executing a stored procedure from
specified roles.
“REVOKE EXECUTE Statement” (page 136)
Data Manipulation Language (DML) Statements
Use these DMLto delete, insert, select, or update rows in one or more tables:
Deletes rows from a table or view.“DELETE Statement” (page 90)
Inserts data into tables and views.“INSERT Statement” (page 121)
Retrieves data from tables and views.“SELECT Statement” (page 141)
Updates values in columns of a table or view.“UPDATE Statement” (page 169)
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 129)
Undoes changes made during a transaction and ends the
transaction.
“ROLLBACK WORK Statement” (page 140)
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 166)
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 101)
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 127)
Compiles an SQL statement for later use with the
EXECUTE statement.
“PREPARE Statement” (page 132)
Updates statistics about the contents of a table and its
indexes.
“UPDATE STATISTICS Statement” (page 175)
42 SQL Statements