Neoview SQL Reference Manual (R2.4)

FLOAT data type, 239
FLOOR function
examples of, 384
syntax diagram of, 384
FORMAT clause
considerations for date formats, 297
considerations for other formats, 297
examples of, 297
syntax diagram, 296
FULL join, description of, 168
Functions, ANSI compliant, 36
G
GET SERVICE statement
examples of, 131
syntax of, 131
GRANT EXECUTE statement
authorization and availability requirements, 135
examples of, 136
syntax diagram of, 135
GRANT SCHEMA statement
authorization and availability requirements, 139
examples of, 140
privileges, 137
syntax diagram of, 137
GRANT statement
authorization and availability requirements, 134
examples of, 134
privileges, 282
syntax diagram of, 133
H
Histogram tables
UPDATE STATISTICS use of, 203
Histograms
clearing, 202
HOUR function
examples of, 385
syntax diagram of, 385
I
Identifiers, 252
IDENTITY column, 74
altering MAXVALUE and INCREMENT BY, 49
considerations for, 85
CREATE SET TABLE statement, 76
examples of, 88
generated always as, 74
generated by default as, 74
generating values, 85
restrictions, 86
system-generated value, 85
IDENTITY columns
altering, 49
incrementing value, 48
setting a maximum value, 48
IN predicate
examples of, 274
logical equivalent using ANY, 274
operand requirements, 274
syntax diagram of, 273
Index keys, 255
Indexes
CREATE INDEX statement, 59
CREATE VOLATILE INDEX statement, 59
description of, 254
DROP INDEX statement, 109
Indexes and materialized views, 65
Inner equi-join query, definition of, 65
INSERT
embedded, examples of, 182
self-referencing, 144
INSERT function
examples of, 386
syntax diagram of, 386
INSERT statement
access options, 143
compatible data types, 144
considerations, 143
examples of, 145
lock modes, 143
ORDER BY clause, 142
query expression within, 142
syntax diagram of, 141
target column list, 141
VALUES specification within, 144
INTEGER data type, 239
Interval data type
description of, 237
examples of literals, 261
Interval literals
description of, 259
examples of, 261
Interval value expression
examples of, 247
syntax diagram of, 246
ISNULL function
examples of, 387
syntax diagram of, 387
ISO standards, 507
Isolation levels
guidelines for CREATE VIEW, 101
READ COMMITTED, 34
READ UNCOMMITTED, 34
REPEATABLE READ, 35
SERIALIZABLE, 29, 35
J
Join
CROSS, 168
FULL, 168
JOIN ON, 168
join predicate, 178
LEFT, 168
limits, 173
NATURAL, 168
NATURAL LEFT, 168
NATURAL RIGHT, 168
521