Neoview SQL Reference Manual (R2.5)

Drops a trigger.“DROP TRIGGER Statement” (page 119)
Drops a view.“DROP VIEW Statement” (page 120)
Grants access privileges for a table or view to specified
roles.
“GRANT Statement” (page 136)
Grants privileges for executing a stored procedure in Java
(SPJ) to specified roles.
“GRANT EXECUTE Statement” (page 138)
Grants access privileges for a schema to specified roles.“GRANT SCHEMA Statement” (page 140)
Revokes access privileges for a table or view from specified
roles.
“REVOKE Statement” (page 156)
Revokes privileges for executing a stored procedure from
specified roles.
“REVOKE EXECUTE Statement” (page 158)
Revokes access privileges for a schema.“REVOKE SCHEMA Statement” (page 160)
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 108)
Inserts data into tables and views.“INSERT Statement” (page 144)
Performs all table maintenance operations.“MERGE INTO Statement” (page 151)
Retrieves data from tables and views.“SELECT Statement” (page 164)
Equivalent to the query specification SELECT * FROM
table
“TABLE Statement” (page 197)
Updates values in columns of a table or view.“UPDATE Statement” (page 198)
Displays the results of the evaluation of the expressions
and the results of row subqueries within the row value
constructors.
“VALUES Statement” (page 210)
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 55)
Commits changes made during a transaction and ends the
transaction.
“COMMIT WORK Statement” (page 59)
Undoes changes made during a transaction and ends the
transaction.
“ROLLBACK WORK Statement” (page 163)
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 188)
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 121)
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 149)
38 SQL Statements