Neoview SQL Reference Manual (R2.3)

Syntax Description of DROP TRIGGER........................................................................................101
Considerations for DROP TRIGGER.............................................................................................101
Authorization and Availability Requirements.........................................................................101
Examples of DROP TRIGGER.......................................................................................................101
DROP VIEW Statement.......................................................................................................................102
Syntax Description of DROP VIEW...............................................................................................102
Considerations for DROP VIEW...................................................................................................102
Authorization and Availability Requirements.........................................................................102
Example of DROP VIEW...............................................................................................................102
EXECUTE Statement...........................................................................................................................103
Syntax Description of EXECUTE...................................................................................................103
Considerations for EXECUTE........................................................................................................104
Scope of EXECUTE...................................................................................................................104
Examples of EXECUTE..................................................................................................................104
EXPLAIN Statement............................................................................................................................106
Syntax.............................................................................................................................................106
Considerations...............................................................................................................................107
Case Considerations.................................................................................................................107
Number Considerations...........................................................................................................107
Formatted [OPTIONS 'f'] Considerations................................................................................107
Normal User [OPTIONS 'n'] Considerations...........................................................................108
Expert User [OPTIONS 'e'] Considerations..............................................................................110
Machine-Readable [OPTIONS 'm'] Considerations.................................................................112
Example of EXPLAIN Statement Using ODBC........................................................................114
Example of EXPLAIN Statement Using JDBC.........................................................................115
GET SERVICE Statement....................................................................................................................117
Syntax.............................................................................................................................................117
Considerations...............................................................................................................................117
Examples........................................................................................................................................117
GRANT Statement..............................................................................................................................118
Syntax Description of GRANT......................................................................................................118
Considerations for GRANT...........................................................................................................119
Authorization and Availability Requirements.........................................................................119
Privileges on Views..................................................................................................................119
Examples of GRANT.....................................................................................................................119
GRANT EXECUTE Statement.............................................................................................................120
Syntax Description of GRANT EXECUTE.....................................................................................120
Considerations for GRANT EXECUTE.........................................................................................120
Authorization and Availability Requirements.........................................................................120
Examples of GRANT EXECUTE....................................................................................................121
GRANT SCHEMA Statement.............................................................................................................122
Syntax Description of GRANT SCHEMA.....................................................................................122
Considerations for GRANT SCHEMA..........................................................................................123
Authorization and Availability Requirements.........................................................................123
Schema Privileges and Synonyms............................................................................................123
Examples of GRANT SCHEMA....................................................................................................123
INSERT Statement...............................................................................................................................124
Syntax Description of INSERT.......................................................................................................124
Considerations for INSERT...........................................................................................................126
Authorization Requirements....................................................................................................126
Transaction Initiation and Termination....................................................................................126
Self-Referencing INSERT and BEGIN WORK or AUTOCOMMIT OFF..................................126
Isolation Levels of Transactions and Access Options of Statements........................................127
Use of a VALUES Clause for the Source Query Expression....................................................127
Requirements for Inserted Rows..............................................................................................127
Table of Contents 7