Neoview SQL Reference Manual (R2.3)

Control Statements
Use these statements to control the execution default options, plans, and performance of DML
statements:
Specifies a dynamic timeout value in the run-time
environment of the current session.
“SET TABLE TIMEOUT Statement” (page 168)
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 166)
Trigger Statements
Use these statements to create and manipulate triggers on SQL tables:
Alters a trigger.“ALTER TRIGGER Statement” (page 50)
Creates a trigger.“CREATE TRIGGER Statement” (page 82)
Drops a trigger.“DROP TRIGGER Statement” (page 101)
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 53)
Grants privileges for executing an SPJ to specified roles.“GRANT EXECUTE Statement” (page 120)
Revokes privileges for executing an SPJ from specified
roles.
“REVOKE EXECUTE Statement” (page 139)
Categories 43