Neoview SQL Reference Manual (R2.4 SP2)

syntax diagram of, 392
F
File options
CREATE INDEX use of, 60
CREATE TABLE use of, 72
Fixed-length character column, 236
FLOAT data type, 242
FLOOR function
examples of, 393
syntax diagram of, 393
FOREIGN KEY constraint, 47, 77, 105, 227
FORMAT clause
considerations for date formats, 305
considerations for other formats, 305
examples of, 305
syntax diagram, 304
FULL join, description of, 169
Functions, ANSI compliant, 34
G
GET SERVICE statement
considerations for, 133
examples of, 133
syntax diagram of, 133
GRANT EXECUTE statement
authorization and availability requirements, 137
considerations for, 137
examples of, 138
syntax diagram of, 137
GRANT SCHEMA statement
authorization and availability requirements, 141
considerations for, 141
examples of, 142
privileges, 139
syntax diagram of, 139
GRANT statement
authorization and availability requirements, 136
considerations for, 136
examples of, 136
privileges, 136, 288
syntax diagram of, 135
H
Hash partition key
description of, 260
Histograms
clearing, 203
UPDATE STATISTICS use of, 204
HOUR function
examples of, 394
syntax diagram of, 394
I
Identifiers, 257
IDENTITY column
altering, 49
altering MAXVALUE and INCREMENT BY, 48
considerations for, 88
CREATE SET TABLE statement, 78
examples of, 90
generated always as, 76
generated by default as, 76
generating values, 87
incrementing value, 48
recalibrating, 49
restrictions, 88
setting a maximum value, 48
system-generated value, 87
IN predicate
examples of, 280
logical equivalent using ANY, 280
operand requirements, 280
syntax diagram of, 279
Index keys, 260
Indexes
and transactions, 61
CREATE INDEX statement, 60
CREATE VOLATILE INDEX statement, 60
description of, 259
DROP INDEX statement, 111
Indexes and materialized views, 66
Inner equi-join query, definition of, 66
INSERT function
examples of, 395
syntax diagram of, 395
INSERT statement
compatible data types, 144
considerations for, 144
embedded, examples of, 182
examples of, 145
self-referencing, 144
side tree, 61
syntax diagram of, 143
target column list, 143
VALUES specification within, 144
INTEGER data type, 241
Internal sequence generator table, 76, 87
Interval data types
description of, 239
Interval literals
description of, 264
examples of, 266
Interval value expression
examples of, 250
syntax diagram of, 249
ISNULL function
examples of, 396
syntax diagram of, 396
ISO standards, 513
Isolation levels
guidelines for CREATE VIEW, 102
READ COMMITTED, 32
READ UNCOMMITTED, 32
REPEATABLE READ, 33
SERIALIZABLE, 26, 27, 33
529