Neoview SQL Reference Manual (R2.4 SP2)

Index
A
ABS function
examples of, 332
syntax diagram of, 332
Access options
summary of, 25
DELETE statement use of, 107
DML statements use of, 25
INSERT statement use of, 143
READ COMMITTED, 26
READ UNCOMMITTED , 26
REPEATABLE READ, 26
SELECT statement use of, 171
SERIALIZABLE, 26, 27, 33
SKIP CONFLICT, 26
UPDATE statement use of, 199
Access privileges
stored procedures, 137
tables, 135, 139
ACOS function
examples of, 333
syntax diagram of, 333
ADD_MONTHS function
examples of, 334
syntax diagram of, 334
AFTER LAST ROW clause, 166
Aggregate functions
summary of, 325
AVG, 339
COUNT, 359
DISTINCT clause, 174, 325
MAX/MAXIMUM, 407
MIN, 408
STDDEV, 457
SUM, 461
VARIANCE, 473
Aliases, schemas, 291
ALTER MATERIALIZED VIEW statement
considerations for, 40
example of, 41
syntax diagram of, 40
ALTER MVGROUP statement
considerations for, 42
examples of, 42
syntax diagram of, 42
ALTER SYNONYM statement
considerations for, 43
example of, 43
syntax diagram of, 43
ALTER TABLE statement
altering IDENTITY columns, 48
authorization and availability requirements, 48
considerations for, 48
constraints implemented with indexes, 48
DEFAULT clause, 302
description for, 45
examples of , 51, 52
recalibrating an IDENTITY column, 49
RENAME TO clause, 47
rules for ALTER COLUMN, 49
syntax diagram of, 44
ALTER TRIGGER statement
considerations for, 53
examples of, 53
syntax diagram of, 53
ALTER VIEW statement
considerations for, 54
example of, 54
syntax diagram of, 54
ANSI
compliance, description of, 33
names, schemas, 291
SQL standards, 513
standards, Neoview SQL compliance, 514
ASCII function
examples of, 335
syntax diagram of, 335
ASIN function
examples of, 336
syntax diagram of, 336
ATAN function
examples of, 337
syntax diagram of, 337
ATAN2 function
examples of, 338
syntax diagram of, 338
AVG function
DISTINCT clause use of, 339
examples of, 339
operand requirements, 339
syntax diagram of, 339
AVG window function
examples of, 481
syntax diagram of, 481
B
BEGIN WORK statement
considerations for, 55
example of, 55
syntax diagram of, 55
BETWEEN predicate
examples of, 274
logical equivalents, 274
operand requirements, 273
syntax diagram of, 273
BITAND function
examples of, 341
syntax diagram of, 341
Boolean operators
NOT, AND, OR, 292
search condition use of, 292
523