Neoview SQL Reference Manual (R2.3)

Stream Access Restrictions.......................................................................................................155
Restrictions on Embedded Inserts............................................................................................155
DISTINCT Aggregate Functions..............................................................................................155
Limitations of DISTINCT Aggregates......................................................................................156
Examples of Multiple Distinct Aggregates..............................................................................156
Considerations for Select List........................................................................................................156
Considerations for SEQUENCE BY...............................................................................................156
Considerations for GROUP BY......................................................................................................156
Considerations for SORT BY.........................................................................................................157
Considerations for ORDER BY......................................................................................................157
Considerations for DISTINCT.......................................................................................................157
Considerations for UNION...........................................................................................................157
Characteristics of the UNION Columns..................................................................................157
ORDER BY Clause and the UNION Operator.........................................................................158
GROUP BY Clause, HAVING Clause, and the UNION Operator ..........................................158
UNION ALL and Associativity................................................................................................158
Access Modes and the UNION Operator.................................................................................158
Examples of SELECT.....................................................................................................................159
Examples for Embedded INSERT..................................................................................................164
SET SCHEMA Statement....................................................................................................................166
Syntax Description of SET SCHEMA............................................................................................166
Consideration for SET SCHEMA...................................................................................................166
Examples of SET SCHEMA...........................................................................................................166
SET SERVICE Statement.....................................................................................................................167
Syntax.............................................................................................................................................167
Considerations...............................................................................................................................167
Examples........................................................................................................................................167
SET TABLE TIMEOUT Statement.......................................................................................................168
Syntax Description of SET TABLE TIMEOUT...............................................................................168
Considerations for SET TABLE TIMEOUT....................................................................................169
Examples of SET TABLE TIMEOUT..............................................................................................169
SET TRANSACTION Statement.........................................................................................................170
Syntax Description of SET TRANSACTION.................................................................................171
Considerations for SET TRANSACTION......................................................................................172
MULTI COMMIT......................................................................................................................172
Implicit Transactions................................................................................................................173
Explicit Transactions.................................................................................................................173
Degree of Concurrency.............................................................................................................174
Effect on Utilities......................................................................................................................174
Example of SET TRANSACTION..................................................................................................174
SHOWDDL Statement........................................................................................................................175
Syntax Description of SHOWDDL................................................................................................175
Considerations for SHOWDDL.....................................................................................................175
Differences Between SHOWDDL Output and Original DDL.......................................................175
PRIVILEGES Option......................................................................................................................176
Examples of SHOWDDL...............................................................................................................176
UPDATE Statement.............................................................................................................................179
Syntax Description of UPDATE.....................................................................................................179
Considerations for UPDATE..........................................................................................................181
Performance..............................................................................................................................181
Authorization Requirements....................................................................................................181
Transaction Initiation and Termination....................................................................................181
Isolation Levels of Transactions and Access Options of Statements........................................181
Conflicting Updates in Concurrent Applications....................................................................182
Requirements for Data in Row.................................................................................................182
Table of Contents 9