Neoview SQL Reference Manual (R2.2)

Examples of LOCK TABLE............................................................................................................128
MERGE INTO Statement....................................................................................................................129
Syntax Description of MERGE INTO............................................................................................129
Considerations for MERGE INTO.................................................................................................129
Upsert Using Single Row.........................................................................................................129
Restrictions..........................................................................................................................130
Upsert Using Rowsets..............................................................................................................130
Example...............................................................................................................................130
MERGE From One Table Into Another....................................................................................130
Example...............................................................................................................................131
Reflexive Updates...............................................................................................................131
PREPARE Statement...........................................................................................................................132
Syntax Description of PREPARE...................................................................................................132
Considerations for PREPARE........................................................................................................132
Availability of a Prepared Statement........................................................................................132
Examples of PREPARE..................................................................................................................132
REVOKE Statement.............................................................................................................................134
Syntax Description of REVOKE.....................................................................................................134
Considerations for REVOKE.........................................................................................................135
Authorization and Availability Requirements.........................................................................135
Examples of REVOKE....................................................................................................................135
REVOKE EXECUTE Statement...........................................................................................................136
Syntax Description of REVOKE EXECUTE...................................................................................136
Considerations for REVOKE EXECUTE........................................................................................137
Authorization and Availability Requirements.........................................................................137
Examples of REVOKE EXECUTE..................................................................................................137
REVOKE SCHEMA Statement............................................................................................................138
Syntax Description of REVOKE SCHEMA....................................................................................138
Considerations for REVOKE SCHEMA........................................................................................139
Authorization and Availability Requirements.........................................................................139
Examples of REVOKE SCHEMA...................................................................................................139
ROLLBACK WORK Statement...........................................................................................................140
Considerations for ROLLBACK WORK........................................................................................140
Begin and End a Transaction....................................................................................................140
Examples of ROLLBACK WORK..................................................................................................140
SELECT Statement..............................................................................................................................141
Syntax Description of SELECT......................................................................................................144
Considerations for SELECT...........................................................................................................151
Authorization Requirements....................................................................................................151
Locking Modes.........................................................................................................................151
Use of Views With SELECT......................................................................................................151
Join Limits.................................................................................................................................152
Object Names in SELECT.........................................................................................................152
AS and ORDER BY Conflicts....................................................................................................152
Stream Access Restrictions.......................................................................................................152
Restrictions on Embedded Inserts............................................................................................152
DISTINCT Aggregate Functions..............................................................................................152
Limitations of DISTINCT Aggregates......................................................................................153
Examples of Multiple Distinct Aggregates..............................................................................153
Considerations for Select List........................................................................................................153
Considerations for SEQUENCE BY...............................................................................................153
Considerations for GROUP BY......................................................................................................153
Considerations for SORT BY.........................................................................................................154
Considerations for ORDER BY......................................................................................................154
Considerations for DISTINCT.......................................................................................................154
8 Table of Contents