Neoview SQL Reference Manual (R2.3)

2 SQL Statements.............................................................................................................41
Categories.............................................................................................................................................41
Data Definition Language (DDL) Statements.................................................................................41
Data Manipulation Language (DML) Statements...........................................................................42
Transaction Control Statements.......................................................................................................42
Resource Control and Optimization Statements.............................................................................42
Control Statements..........................................................................................................................43
Object Naming Statements..............................................................................................................43
Trigger Statements...........................................................................................................................43
Stored Procedure Statements...........................................................................................................43
ALTER MATERIALIZED VIEW Statement..........................................................................................44
Syntax Description of ALTER MATERIALIZED VIEW..................................................................44
Considerations for ALTER MATERIALIZED VIEW.......................................................................44
ALTER MVGROUP Statement..............................................................................................................45
Considerations for ALTER MVGROUP..........................................................................................45
Example of ALTER MVGROUP......................................................................................................45
ALTER SYNONYM Statement..............................................................................................................46
Syntax Description of ALTER SYNONYM .....................................................................................46
Considerations.................................................................................................................................46
Example of ALTER SYNONYM......................................................................................................46
ALTER TABLE Statement.....................................................................................................................47
Syntax Description of ALTER TABLE.............................................................................................47
Considerations for ALTER TABLE..................................................................................................49
Effect of Adding a Column on View Definitions.......................................................................49
Authorization and Availability Requirements...........................................................................49
Example of ALTER TABLE..............................................................................................................49
ALTER TRIGGER Statement.................................................................................................................50
Syntax Description of ALTER TRIGGER.........................................................................................50
Considerations for ALTER TRIGGER.............................................................................................50
Authorization and Availability Requirements...........................................................................50
ALTER VIEW Statement.......................................................................................................................51
Syntax Description of ALTER VIEW...............................................................................................51
Authorization and Availability Requirements................................................................................51
Example of ALTER VIEW................................................................................................................51
BEGIN WORK Statement.....................................................................................................................52
Examples of BEGIN WORK............................................................................................................52
CALL Statement....................................................................................................................................53
Syntax Description of CALL............................................................................................................53
Considerations for CALL................................................................................................................53
Usage Restrictions......................................................................................................................53
Required Privileges....................................................................................................................53
Input Parameter Arguments......................................................................................................54
Output Parameter Arguments...................................................................................................54
Data Conversion of Parameter Arguments................................................................................54
Null Input and Output...............................................................................................................54
Transaction Semantics................................................................................................................54
Examples of CALL...........................................................................................................................54
COMMIT WORK Statement.................................................................................................................56
Considerations for COMMIT WORK..............................................................................................56
Begin and End a Transaction......................................................................................................56
Effect of Constraints...................................................................................................................56
Example of COMMIT WORK..........................................................................................................56
CREATE INDEX Statement...................................................................................................................58
Syntax Description of CREATE INDEX..........................................................................................58
4 Table of Contents