Neoview SQL Reference Manual (R2.4 SP2)

Examples of MAINTAIN...............................................................................................................215
POPULATE INDEX Utility.................................................................................................................218
Syntax Description of POPULATE INDEX....................................................................................218
Considerations for POPULATE INDEX........................................................................................218
Examples of POPULATE INDEX...................................................................................................219
PURGEDATA Utility...........................................................................................................................220
Syntax Description of PURGEDATA.............................................................................................220
Considerations for PURGEDATA..................................................................................................220
Example of PURGEDATA.............................................................................................................221
4 SQL Language Elements...........................................................................................223
Character Sets......................................................................................................................................224
Columns..............................................................................................................................................225
Column References........................................................................................................................225
Derived Column Names................................................................................................................225
Column Default Settings................................................................................................................226
Constraints..........................................................................................................................................227
Creating, Adding, and Dropping Constraints on SQL Tables.......................................................227
Correlation Names..............................................................................................................................228
Explicit Correlation Names...........................................................................................................228
Implicit Correlation Names...........................................................................................................228
Examples of Correlation Names....................................................................................................228
Database Objects.................................................................................................................................229
Ownership.....................................................................................................................................229
Database Object Names......................................................................................................................230
Logical Names for SQL Objects.....................................................................................................230
SQL Object Namespaces................................................................................................................230
Data Types...........................................................................................................................................231
Comparable and Compatible Data Types.....................................................................................233
Character String Data Types..........................................................................................................235
Datetime Data Types......................................................................................................................237
Interval Data Types........................................................................................................................239
Numeric Data Types .....................................................................................................................241
Expressions..........................................................................................................................................243
Character Value Expressions.........................................................................................................243
Datetime Value Expressions..........................................................................................................245
Interval Value Expressions............................................................................................................249
Numeric Value Expressions...........................................................................................................253
Identifiers............................................................................................................................................257
Regular Identifiers.........................................................................................................................257
Delimited Identifiers......................................................................................................................257
Examples of Identifiers..................................................................................................................257
Indexes................................................................................................................................................259
SQL Indexes...................................................................................................................................259
Keys.....................................................................................................................................................260
Clustering Keys..............................................................................................................................260
Hash Partition Keys.......................................................................................................................260
Index Keys.....................................................................................................................................260
Primary Keys.................................................................................................................................260
Literals.................................................................................................................................................261
Character String Literals................................................................................................................261
Datetime Literals............................................................................................................................262
Interval Literals..............................................................................................................................264
Numeric Literals............................................................................................................................266
8 Table of Contents