Neoview SQL Reference Manual (R2.5)

Syntax Description of POPULATE INDEX....................................................................................220
Considerations for POPULATE INDEX........................................................................................220
Examples of POPULATE INDEX...................................................................................................221
PURGEDATA Utility...........................................................................................................................222
Syntax Description of PURGEDATA.............................................................................................222
Considerations for PURGEDATA..................................................................................................222
Example of PURGEDATA.............................................................................................................223
REPLICATE Command.......................................................................................................................224
Syntax Description of REPLICATE ...............................................................................................225
Considerations for REPLICATE ....................................................................................................226
Examples of REPLICATE...............................................................................................................230
4 SQL Language Elements...........................................................................................233
Character Sets......................................................................................................................................234
Columns..............................................................................................................................................235
Column References........................................................................................................................235
Derived Column Names................................................................................................................235
Column Default Settings................................................................................................................236
Constraints..........................................................................................................................................237
Creating, Adding, and Dropping Constraints on SQL Tables.......................................................237
Correlation Names..............................................................................................................................238
Explicit Correlation Names...........................................................................................................238
Implicit Correlation Names...........................................................................................................238
Examples of Correlation Names....................................................................................................238
Cursors................................................................................................................................................239
ANSI Holdable Cursors in JDBC Client Applications..................................................................239
Database Objects.................................................................................................................................241
Ownership.....................................................................................................................................241
Database Object Names......................................................................................................................242
Logical Names for SQL Objects.....................................................................................................242
SQL Object Namespaces................................................................................................................242
Data Types...........................................................................................................................................243
Comparable and Compatible Data Types.....................................................................................245
Character String Data Types..........................................................................................................248
Datetime Data Types......................................................................................................................250
Interval Data Types........................................................................................................................251
Numeric Data Types .....................................................................................................................253
Expressions..........................................................................................................................................255
Character Value Expressions.........................................................................................................255
Datetime Value Expressions..........................................................................................................257
Interval Value Expressions............................................................................................................261
Numeric Value Expressions...........................................................................................................265
Identifiers............................................................................................................................................269
Regular Identifiers.........................................................................................................................269
Delimited Identifiers......................................................................................................................269
Examples of Identifiers..................................................................................................................269
Indexes................................................................................................................................................271
SQL Indexes...................................................................................................................................271
Keys.....................................................................................................................................................272
Clustering Keys..............................................................................................................................272
SYSKEY..........................................................................................................................................272
Hash Partition Keys.......................................................................................................................273
Index Keys.....................................................................................................................................273
Primary Keys.................................................................................................................................273
8 Table of Contents