Neoview SQL Reference Manual (R2.5)

Expression
character (or string) value, 255
datetime value, 257, 258, 262
description of, 255
interval value, 258, 262
numeric value, 265
Extended numeric precision, 246
Extensions, statements, 34
EXTRACT function
examples of, 404
syntax diagram of, 404
F
File options
CREATE INDEX use of, 60
CREATE TABLE use of, 72
Fixed-length character column, 249
FLOAT data type, 254
FLOOR function
examples of, 405
syntax diagram of, 405
FOREIGN KEY constraint, 47, 77, 106, 237
FORMAT clause
considerations for date formats, 317
considerations for other formats, 317
examples of, 317
syntax diagram, 316
FULL join, description of, 170
Functions, ANSI compliant, 34
G
GET SERVICE statement
considerations for, 134
examples of, 134
syntax diagram of, 134
GRANT EXECUTE statement
authorization and availability requirements, 138
considerations for, 138
examples of, 139
syntax diagram of, 138
GRANT SCHEMA statement
authorization and availability requirements, 142
considerations for, 142
examples of, 143
privileges, 140
syntax diagram of, 140
GRANT statement
authorization and availability requirements, 137
considerations for, 137
examples of, 137
privileges, 137, 301
syntax diagram of, 136
H
Hash partition key
description of, 273
Histograms
clearing, 205
UPDATE STATISTICS use of, 205
HOUR function
examples of, 406
syntax diagram of, 406
I
Identifiers, 269
IDENTITY column
altering, 49
altering MAXVALUE and INCREMENT BY, 48
considerations for, 88
CREATE SET TABLE statement, 79
examples of, 91
generated always as, 76
generated by default as, 76
generating values, 88
incrementing value, 48
recalibrating, 49
restrictions, 89
setting a maximum value, 48
system-generated value, 88
IN predicate
examples of, 293
logical equivalent using ANY, 293
operand requirements, 293
syntax diagram of, 292
Index keys, 273
Indexes
and transactions, 61
CREATE INDEX statement, 60
CREATE VOLATILE INDEX statement, 60
description of, 271
DROP INDEX statement, 113
Indexes and materialized views, 66
Inner equi-join query, definition of, 67
INSERT function
examples of, 407
syntax diagram of, 407
INSERT statement
compatible data types, 145
considerations for, 145
embedded, examples of, 183
examples of, 146
self-referencing, 145
side tree, 61
syntax diagram of, 144
target column list, 144
VALUES specification within, 145
INTEGER data type, 253
Internal sequence generator table, 76, 88
Interval data types
description of, 251
Interval literals
description of, 277
examples of, 279
Interval value expression
examples of, 262
syntax diagram of, 261
ISNULL function
examples of, 408
541