Neoview SQL Reference Manual (R2.3)

Index
A
ABS function
examples of, 296, 298
syntax diagram of, 296
Access options
summary of, 30
DELETE statement use of, 92
DML statements use of, 30
INSERT statement use of, 124
READ COMMITTED, 30
READ UNCOMMITTED , 30
REPEATABLE READ, 31
SELECT statement use of, 153
SERIALIZABLE, 31, 37
SKIP CONFLICT, 31
UPDATE statement use of, 181
Access privileges
stored procedures, 120
tables, 118, 122
ACOS function
examples of, 297
syntax diagram of, 297, 298
AFTER LAST ROW clause, 148
Aggregate functions
summary of, 289
AVG, 303
COUNT, 321
DISTINCT clause, 155, 289
MIN, 373
STDDEV, 420
SUM, 424
VARIANCE, 441
Aggregate string functions
COUNT , 321
Aliases
schemas, 257
aligned record format, 76
ALTER MATERIALIZED VIEW statement
syntax description for, 44
syntax diagram of, 44
ALTER MVGROUP statement, syntax description of, 45
ALTER SYNONYM statement, 46
example of, 46
syntax diagram of, 46
ALTER TABLE statement
authorization and availability requirements, 49
constraints implemented with indexes, 49
DEFAULT clause, 268
syntax description for, 47
syntax diagram of, 47
ALTER TABLE statement,
RENAME TO clause, 48
ALTER TRIGGER statement
authorization and availability requirements, 50
ALTER VIEW statement
syntax description for, 51
syntax diagram of, 51
ANSI
compliance, description of, 37
SQL standards, 465
standards, Neoview SQL compliance, 466
ANSI names
schemas, 257
ASCII function
examples of, 299
syntax diagram of, 299
ASIN function
examples of, 300
syntax diagram of, 300
ATAN function
examples of, 301
syntax diagram of, 301
ATAN2 function
examples of, 302
syntax diagram of, 302
authorization and availability requirements, 75
authorization ID, 29
AVG function
DISTINCT clause use of, 303
examples of, 303
operand requirements, 303
syntax diagram of, 303
AVG window function
DISTINCT clause use of, 448
examples of, 448
syntax diagram of, 447
B
BEGIN WORK statement
syntax diagram of, 52
BETWEEN predicate
examples of, 244
logical equivalents, 244
operand requirements, 243
syntax diagram of, 243
BIT functions
BITAND, 304
BITAND function
syntax diagram of, 304
Boolean operators
NOT, AND, OR, 258
search condition use of, 258
C
CALL statement
examples of, 54
syntax diagram of, 53
CASE expression
data type of, 307
examples of, 307
searched CASE form, 306
471