Neoview SQL Reference Manual (R2.3)

Using Compatible Data Types..................................................................................................127
Examples of INSERT......................................................................................................................128
Examples of Self-Referencing Inserts.......................................................................................129
LOCK TABLE Statement.....................................................................................................................130
Syntax Description of LOCK TABLE.............................................................................................130
Considerations for LOCK TABLE..................................................................................................130
Authorization Requirements....................................................................................................130
Modifying Default Locking......................................................................................................130
Effect of AUTOCOMMIT Option.............................................................................................130
Indexes......................................................................................................................................131
Examples of LOCK TABLE............................................................................................................131
MERGE INTO Statement....................................................................................................................132
Syntax Description of MERGE INTO............................................................................................132
Considerations for MERGE INTO.................................................................................................132
Upsert Using Single Row.........................................................................................................132
Restrictions..........................................................................................................................133
Upsert Using Rowsets..............................................................................................................133
Example...............................................................................................................................133
MERGE From One Table Into Another....................................................................................133
Example...............................................................................................................................134
Reflexive Updates...............................................................................................................134
PREPARE Statement...........................................................................................................................135
Syntax Description of PREPARE...................................................................................................135
Considerations for PREPARE........................................................................................................135
Availability of a Prepared Statement........................................................................................135
Examples of PREPARE..................................................................................................................135
REVOKE Statement.............................................................................................................................137
Syntax Description of REVOKE.....................................................................................................137
Considerations for REVOKE.........................................................................................................138
Authorization and Availability Requirements.........................................................................138
Examples of REVOKE....................................................................................................................138
REVOKE EXECUTE Statement...........................................................................................................139
Syntax Description of REVOKE EXECUTE...................................................................................139
Considerations for REVOKE EXECUTE........................................................................................140
Authorization and Availability Requirements.........................................................................140
Examples of REVOKE EXECUTE..................................................................................................140
REVOKE SCHEMA Statement............................................................................................................141
Syntax Description of REVOKE SCHEMA....................................................................................141
Considerations for REVOKE SCHEMA........................................................................................142
Authorization and Availability Requirements.........................................................................142
Examples of REVOKE SCHEMA...................................................................................................142
ROLLBACK WORK Statement...........................................................................................................143
Considerations for ROLLBACK WORK........................................................................................143
Begin and End a Transaction....................................................................................................143
Examples of ROLLBACK WORK..................................................................................................143
SELECT Statement..............................................................................................................................144
Syntax Description of SELECT......................................................................................................147
Considerations for SELECT...........................................................................................................154
Authorization Requirements....................................................................................................154
Performance..............................................................................................................................154
Locking Modes.........................................................................................................................154
Use of Views With SELECT......................................................................................................154
Join Limits.................................................................................................................................155
Object Names in SELECT.........................................................................................................155
AS and ORDER BY Conflicts....................................................................................................155
8 Table of Contents