Neoview SQL Reference Manual (R2.4)

Examples of REVOKE SCHEMA...................................................................................................160
ROLLBACK WORK Statement...........................................................................................................161
Syntax Description of ROLLBACK WORK...................................................................................161
Considerations for ROLLBACK WORK........................................................................................161
Examples of ROLLBACK WORK..................................................................................................161
SELECT Statement..............................................................................................................................162
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.................................................................................188
Considerations for SET TRANSACTION......................................................................................189
Example of SET TRANSACTION..................................................................................................191
SHOWDDL Statement........................................................................................................................192
Syntax Description of SHOWDDL................................................................................................192
Considerations for SHOWDDL.....................................................................................................192
Examples of SHOWDDL...............................................................................................................193
UPDATE Statement.............................................................................................................................196
Syntax Description of UPDATE.....................................................................................................196
Considerations for UPDATE..........................................................................................................198
Examples of UPDATE....................................................................................................................200
UPDATE STATISTICS Statement........................................................................................................202
Syntax Description of UPDATE STATISTICS................................................................................202
Considerations for UPDATE STATISTICS.....................................................................................205
Examples of UPDATE STATISTICS...............................................................................................206
3 SQL Utilities................................................................................................................209
Privileges Required to Execute Utilities .............................................................................................209
MAINTAIN Command.......................................................................................................................210
Syntax Description of MAINTAIN................................................................................................211
MAINTAIN MVGROUP................................................................................................................214
Examples of MAINTAIN...............................................................................................................215
POPULATE INDEX Utility.................................................................................................................218
Syntax Description of POPULATE INDEX....................................................................................218
Considerations for POPULATE INDEX........................................................................................218
Examples of POPULATE INDEX...................................................................................................218
PURGEDATA Utility...........................................................................................................................219
Syntax Description of PURGEDATA.............................................................................................219
Considerations for PURGEDATA..................................................................................................219
Examples of PURGEDATA............................................................................................................219
Table of Contents 7