Neoview SQL Reference Manual (R2.4)

4 SQL Language Elements...........................................................................................221
Character Sets......................................................................................................................................222
Columns..............................................................................................................................................223
Column References........................................................................................................................223
Derived Column Names................................................................................................................223
Column Default Settings................................................................................................................223
Examples of Derived Column Names...........................................................................................224
Constraints..........................................................................................................................................225
Creating, Adding, and Dropping Constraints on SQL Tables.......................................................225
Correlation Names..............................................................................................................................226
Explicit Correlation Names...........................................................................................................226
Implicit Correlation Names...........................................................................................................226
Examples of Correlation Names....................................................................................................226
Database Objects.................................................................................................................................227
Ownership.....................................................................................................................................227
Database Object Names......................................................................................................................228
Logical Names for SQL Objects.....................................................................................................228
SQL Object Namespaces................................................................................................................228
Data Types...........................................................................................................................................229
Comparable and Compatible Data Types.....................................................................................231
Character String Data Types..........................................................................................................233
Datetime Data Types......................................................................................................................235
Interval Data Types........................................................................................................................237
Numeric Data Types .....................................................................................................................238
Expressions..........................................................................................................................................240
Character Value Expressions.........................................................................................................240
Datetime Value Expressions..........................................................................................................242
Interval Value Expressions............................................................................................................246
Numeric Value Expressions...........................................................................................................250
Identifiers............................................................................................................................................252
Regular Identifiers.........................................................................................................................252
Delimited Identifiers......................................................................................................................252
Examples of Identifiers..................................................................................................................252
Indexes................................................................................................................................................254
SQL Indexes...................................................................................................................................254
Keys.....................................................................................................................................................255
Clustering Keys..............................................................................................................................255
Index Keys.....................................................................................................................................255
Primary Keys.................................................................................................................................255
Literals.................................................................................................................................................256
Character String Literals................................................................................................................256
Datetime Literals............................................................................................................................257
Interval Literals..............................................................................................................................258
Numeric Literals............................................................................................................................261
Materialized Views.............................................................................................................................263
Types of Materialized Views..........................................................................................................263
MVGROUPs .......................................................................................................................................264
Null......................................................................................................................................................265
Using Null Versus Default Values.................................................................................................265
Defining Columns That Allow or Prohibit Null............................................................................265
Partitions.............................................................................................................................................266
Automatically Creating Partitions.................................................................................................266
Predicates............................................................................................................................................267
BETWEEN Predicate......................................................................................................................267
8 Table of Contents