Neoview SQL Reference Manual (R2.4)
Index
A
ABS function
examples of, 324, 326
syntax diagram of, 324
Access options
summary of, 28
DELETE statement use of, 106
DML statements use of, 28
INSERT statement use of, 141
READ COMMITTED, 28
READ UNCOMMITTED , 28
REPEATABLE READ, 29
SELECT statement use of, 171
SERIALIZABLE, 28, 29, 35
SKIP CONFLICT, 29
UPDATE statement use of, 198
Access privileges
stored procedures, 135
tables, 133, 137
ACOS function
examples of, 325
syntax diagram of, 325, 326
AFTER LAST ROW clause, 166
Aggregate functions
summary of, 317
AVG, 331
COUNT, 350
DISTINCT clause, 174, 317
MAX/MAXIMUM, 402
MIN, 403
STDDEV, 452
SUM, 456
VARIANCE, 475
Aggregate string functions
COUNT , 350
Aliases, schemas, 285
ALTER MATERIALIZED VIEW statement
description for, 42
syntax diagram of, 42
ALTER MVGROUP statement
considerations for, 43
examples of, 43
syntax description of, 43
ALTER SYNONYM statement, 44
considerations for, 44
example of, 44
syntax diagram of, 44
ALTER TABLE statement
altering IDENTITY columns, 49
authorization and availability requirements, 49
constraints implemented with indexes, 49
DEFAULT clause, 294
description for, 47
example of, 50
example of ALTER COLUMN, 50
RENAME TO clause, 48
rules for ALTER COLUMN, 49
syntax diagram of, 46
ALTER TRIGGER statement
authorization and availability requirements, 52
syntax diagram of, 52
ALTER VIEW statement
description for, 53
example of, 53
syntax diagram of, 53
ANSI
compliance, description of, 35
names, schemas, 285
SQL standards, 507
standards, Neoview SQL compliance, 508
ASCII function
examples of, 327
syntax diagram of, 327
ASIN function
examples of, 328
syntax diagram of, 328
ATAN function
examples of, 329
syntax diagram of, 329
ATAN2 function
examples of, 330
syntax diagram of, 330
Authorization ID, 27
AVG function
DISTINCT clause use of, 331
examples of, 331
operand requirements, 331
syntax diagram of, 331
AVG window function
examples of, 483
syntax diagram of, 483
B
BEGIN WORK statement
examples of, 54
syntax diagram of, 54
BETWEEN predicate
examples of, 268
logical equivalents, 268
operand requirements, 267
syntax diagram of, 267
BITAND function
syntax diagram of, 333
Boolean operators
NOT, AND, OR, 286
search condition use of, 286
C
CALL statement
description for, 55
examples of, 56
515