Neoview SQL Reference Manual (R2.4)

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 185)
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 184)
Trigger Statements
Use these statements to create and manipulate triggers on SQL tables:
Alters a trigger.“ALTER TRIGGER Statement” (page 52)
Creates a trigger.“CREATE TRIGGER Statement” (page 93)
Drops a trigger.“DROP TRIGGER Statement” (page 115)
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 55)
Grants privileges for executing an SPJ to specified roles.“GRANT EXECUTE Statement” (page 135)
Revokes privileges for executing an SPJ from specified
roles.
“REVOKE EXECUTE Statement” (page 156)
Categories 41