Neoview SQL Reference Manual (R2.5)

Compiles an SQL statement for later use with the
EXECUTE statement.
“PREPARE Statement” (page 154)
Updates statistics about the contents of a table and its
indexes.
“UPDATE STATISTICS Statement” (page 204)
Control Statements
Use these statements to control the execution default options, plans, and performance of DML
statements:
Specifies a dynamic timeout value in the runtime
environment of the current session.
“SET TABLE TIMEOUT Statement” (page 186)
Object Naming Statements
Use these statements to specify default ANSI names for the schema:
Sets the default ANSI schema for unqualified object names
for the current session.
“SET SCHEMA Statement” (page 185)
Stored Procedure Statements
Use these statements to execute stored procedures in Java (SPJs) and to modify authorization to
execute SPJs:
Initiates the execution of an SPJ in a Neoview database.“CALL Statement” (page 56)
Grants privileges for executing an SPJ to specified roles.“GRANT EXECUTE Statement” (page 138)
Revokes privileges for executing an SPJ from specified
roles.
“REVOKE EXECUTE Statement” (page 158)
Categories 39