Neoview SQL Reference Manual (R2.4)

JULIANTIMESTAMP inverse relationship to, 347
syntax diagram of, 347
CONVERTTOHEX function
examples of, 345, 346
syntax diagram of, 345
Correlation names
examples of, 226
purpose of, 226
table reference use of, 226
COS function
examples of, 348
syntax diagram of, 348
COSH function
examples of, 349
syntax diagram of, 349
COUNT function
DISTINCT clause within, 350
examples of, 350
syntax diagram of, 350
COUNT window function
examples of, 485
syntax diagram of, 485
CREATE INDEX statement
authorization and availability requirements , 60
examples of, 60
limits on indexes, 60, 505
syntax diagram of, 59
volatile index, 59
CREATE MATERIALIZED VIEW statement
authorization, 64
clustering, 64
considerations for, 63
description for, 62
examples of, 66
joins, 65
restrictions for, 65
syntax diagram of, 61
types of materialized views, 63
CREATE MVGROUP statement
authorization and availability requirements, 67
example of, 67
syntax diagram of, 67
CREATE SCHEMA statement
considerations for, 68
description of, 68
example of, 68
reserved schema names, 68
syntax diagram of, 68
CREATE SET TABLE statement, 70
considerations for, 76
example, 76
examples of, 90
IDENTITY column, 76
restrictions, 76
syntax, 70
CREATE SYNONYM statement, 69
considerations of, 69
example of, 69
syntax diagram of, 69
CREATE TABLE AS statement
considerations for, 76, 82
example of, 82
examples of, 91
IDENTITY columns, 82
syntax diagram of, 70
CREATE TABLE LIKE statement
considerations for, 79
example of, 80
IDENTITY columns, 79
recalibrating the current value of sequence generator
table, 81
syntax diagram of, 70
CREATE TABLE statement
authorization and availability requirements, 84
calculating row size, 84
considerations for, 76
DEFAULT clause, 294
description for, 72
DISK POOL, 73, 89
examples of, 89
examples of IDENTITY columns, 87
IDENTITY column, 74
IDENTITY columns, considerations, 85
limits, 84
Neoview SQL extensions, 89
partitioning, 84
reserved table names, 83
restrictions on IDENTITY columns, 86
syntax diagram of, 70
table size, 73
CREATE TRIGGER statement
authorization and availability requirements, 94
considerations for, 94
description of, 93
examples of, 97
restrictions, 96
syntax diagram of, 93
types of triggers, 95
CREATE VIEW statement
authorization and availability requirements, 100
examples of, 103
ORDER BY clause, 102
syntax diagram of, 99
updatability requirements, 101
vertical partition example, 103
WITH CHECK OPTION within, 100
CREATE VOLATILE INDEX statement
syntax diagram of, 59
CREATE VOLATILE TABLE statement
considerations for, 77
examples of, 79, 89
nullable constraints, 78
nullable keys, 77
restrictions, 77
SET table, example of, 91
suitable keys, 78
syntax diagram of, 70
Cross join, definition of, 65
517