Neoview SQL Reference Manual (R2.4 SP2)

FOREIGN KEY, 46, 77, 227
limits, 511
NOT NULL, 227
PRIMARY KEY, 227
CONVERTTIMESTAMP function
examples of, 356
JULIANTIMESTAMP inverse relationship to, 356
syntax diagram of, 356
CONVERTTOHEX function
examples of, 354, 355
syntax diagram of, 354
Correlation names
examples of, 228
purpose of, 228
table reference use of, 228
COS function
examples of, 357
syntax diagram of, 357
COSH function
examples of, 358
syntax diagram of, 358
COUNT function
DISTINCT clause within, 359
examples of, 359
syntax diagram of, 359
COUNT window function
examples of, 483
syntax diagram of, 483
CREATE INDEX statement
authorization requirements , 61
considerations for, 61
example of, 62
limits on indexes, 62, 511
syntax diagram of, 60
volatile index, 60
CREATE MATERIALIZED VIEW statement
authorization, 65
clustering, 66
considerations for, 65
examples of, 67
joins, 66
restrictions for, 67
syntax diagram of, 63
types of materialized views, 65, 268
CREATE MVGROUP statement
authorization requirements, 69
example of, 69
syntax diagram of, 69
CREATE SCHEMA statement
considerations for, 70
example of, 70
reserved schema names, 70
syntax diagram of, 70
CREATE SET TABLE statement
considerations for, 78
examples of, 79, 93
IDENTITY column, 78
restrictions, 78
syntax diagram of, 72
CREATE SYNONYM statement, 71
considerations for, 71
example of, 71
syntax diagram of, 71
CREATE TABLE AS statement
considerations for, 84
examples of, 84, 93
IDENTITY columns, 84
LOAD IF EXISTS, 84
syntax diagram of, 72
CREATE TABLE LIKE statement
considerations for, 81
example of, 82
IDENTITY columns, 81
recalibrating the IDENTITY column, 83
syntax diagram of, 72
CREATE TABLE statement
authorization and availability requirements, 86
calculating row size, 86
considerations for, 78
DEFAULT clause, 302
DISK POOL, 75, 91
examples of , 89, 92
IDENTITY column, 76, 88
limits, 86
Neoview SQL extensions, 91
partitioning, 87
reserved table names, 86
restrictions on IDENTITY columns, 88
syntax diagram of, 72
table size, 74
CREATE TRIGGER statement
authorization and availability requirements, 96
considerations for, 96
examples of, 99
recompilation , 98
restrictions, 98
syntax diagram of, 95
types of triggers, 97
CREATE VIEW statement
considerations for, 102
examples of, 104
isolation level guidelines, 102
ORDER BY clause, 103
reserved view names, 102
syntax diagram of, 101
updatability requirements, 102
vertical partition example, 105
WITH CHECK OPTION within, 101
CREATE VOLATILE INDEX statement
syntax diagram of, 60
CREATE VOLATILE TABLE statement
considerations for, 79
examples of, 81, 92
nullable constraints, 80
nullable keys, 79
restrictions, 79
SET table, example of, 93
suitable keys, 80
525