Neoview Command Interface (NCI) Guide (R2.4)

DescriptionSQL Statement
Executes an SQL statement previously compiled by a PREPARE
statement.
EXECUTE
Helps you review query execution plans.EXPLAIN
Grants access privileges for a table or view to specified users.GRANT
Grants privileges for executing a stored procedure in Java (SPJ) to
specified roles.
GRANT EXECUTE
Grants access privileges for a schema to specified roles.GRANT SCHEMA
Inserts rows of data into a table or view.INSERT
Locks the specified table (or underlying tables of a view) and its
associated indexes for the duration of the active transaction.
LOCK TABLE
Performs one or more table maintenance tasks, such as REORG,
UPDATE STATISTICS, and REFRESH, on a specified database object.
MAINTAIN
Performs all table maintenance operations.MERGE INTO
Loads a specified index with data from a specified table.POPULATE INDEX
Compiles an SQL statement for later use with the EXECUTE statement.PREPARE
Deletes all data from a table and its related indexes.PURGEDATA
Reorganizes data in a table or index and compacts space needed for
rows by removing unused space.
REORG
Revokes access privileges for a table or view from specified users.REVOKE
Revokes privileges for executing a stored procedure from specified
roles.
REVOKE EXECUTE
Undoes all modifications to database objects during the current
transaction, releases all locks on database objects held by the
transaction, and ends the transaction.
ROLLBACK WORK
Retrieves data from tables, views, derived tables determined by the
evaluation of query expressions, or joined tables.
SELECT
Sets the schema name for unqualified object names for the current
session.
SET SCHEMA
Sets a dynamic timeout value for a lock timeout or a stream timeout
in the environment of the current session.
SET TABLE TIMEOUT
Sets attributes, such as isolation level and access mode, for the next
transaction.
SET TRANSACTION
Shows the service.SHOW SERVICE
Updates data in a row or rows of a table or updateable view.UPDATE
Updates histogram statistics for one or more groups of columns in a
table.
UPDATE STATISTICS
160 Supported SQL Statements