Neoview SQL Reference Manual (R2.4 SP2)

Examples of REVOKE EXECUTE..................................................................................................158
REVOKE SCHEMA Statement............................................................................................................159
Syntax Description of REVOKE SCHEMA....................................................................................159
Considerations for REVOKE SCHEMA........................................................................................161
Examples of REVOKE SCHEMA...................................................................................................161
ROLLBACK WORK Statement...........................................................................................................162
Syntax Description of ROLLBACK WORK...................................................................................162
Considerations for ROLLBACK WORK........................................................................................162
Example of ROLLBACK WORK....................................................................................................162
SELECT Statement..............................................................................................................................163
Syntax Description of SELECT......................................................................................................165
Considerations for SELECT...........................................................................................................172
Considerations for Select List........................................................................................................174
Considerations for SEQUENCE BY...............................................................................................174
Considerations for GROUP BY......................................................................................................174
Considerations for ORDER BY......................................................................................................175
Considerations for UNION...........................................................................................................175
Examples of SELECT.....................................................................................................................177
SET SCHEMA Statement....................................................................................................................184
Syntax Description of SET SCHEMA............................................................................................184
Consideration for SET SCHEMA...................................................................................................184
Examples of SET SCHEMA...........................................................................................................184
SET TABLE TIMEOUT Statement.......................................................................................................185
Syntax Description of SET TABLE TIMEOUT...............................................................................185
Considerations for SET TABLE TIMEOUT....................................................................................186
Examples of SET TABLE TIMEOUT..............................................................................................186
SET TRANSACTION Statement.........................................................................................................187
Syntax Description of SET TRANSACTION.................................................................................187
Considerations for SET TRANSACTION......................................................................................189
Examples of SET TRANSACTION................................................................................................191
SHOWDDL Statement........................................................................................................................192
Syntax Description of SHOWDDL................................................................................................192
Considerations for SHOWDDL.....................................................................................................192
Examples of SHOWDDL...............................................................................................................193
TABLE Statement................................................................................................................................196
Considerations for TABLE.............................................................................................................196
Examples of TABLE.......................................................................................................................196
UPDATE Statement.............................................................................................................................197
Syntax Description of UPDATE.....................................................................................................197
Considerations for UPDATE..........................................................................................................199
Examples of UPDATE....................................................................................................................201
UPDATE STATISTICS Statement........................................................................................................203
Syntax Description of UPDATE STATISTICS................................................................................203
Considerations for UPDATE STATISTICS.....................................................................................206
Examples of UPDATE STATISTICS...............................................................................................207
VALUES Statement.............................................................................................................................208
Considerations for VALUES..........................................................................................................208
Examples of VALUES....................................................................................................................208
3 SQL Utilities................................................................................................................209
Privileges Required to Execute Utilities .............................................................................................209
MAINTAIN Command.......................................................................................................................210
Syntax Description of MAINTAIN................................................................................................211
MAINTAIN MVGROUP................................................................................................................215
Table of Contents 7