Neoview SQL Reference Manual (R2.2)

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 164)
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 163)
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 81)
Drops a trigger.“DROP TRIGGER Statement” (page 99)
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 117)
Revokes privileges for executing an SPJ from specified
roles.
“REVOKE EXECUTE Statement” (page 136)
Categories 43