Neoview SQL Reference Manual (R2.3)

TRANSPOSE clause
cardinality of result, 283
degree of result, 282
examples of, 283
SELECT statement use of, 281
syntax diagram of, 281
Trigger statements, 43
Triggers
ALTER TRIGGER statement, 50
considerations, 83
CREATE TRIGGER statement, 82
description, 263
DROP TRIGGER statement, 101
TRIM function
examples of, 429
syntax diagram of, 429
U
UCASE function
examples of, 436
syntax diagram of, 430
Union operation
associative, UNION ALL, 158
columns, characteristics of, 157
ORDER BY clause restriction, 158
SELECT statement use of, 153
Updatable view, requirements for, 90
UPDATE statement
authorization requirements, 181
conflicting updates, 182
performance, 181
SET clause, 180
SET ON ROLLBACK clause, 180
SET ROLLBACK clause, 180
SKIP CONFLICT access, 181
syntax diagram of, 179
WHERE clause, 181
UPDATE STATISTICS statement
column groups, 186
column lists, 186
examples of, 189
histogram tables, 186
syntax diagram of, 185
table row count, 188
UPPER function
examples of, 438
syntax diagram of, 438
upsert
using rowsets, 133
using single row, 132
upsert functionality, 132
UPSHIFT function
syntax diagram of, 439
USER function
example of, 440
syntax diagram of, 440
Utilities
PURGEDATA, 198
V
Value expression, 218
Value expressions
summary of, 295
CASE (Conditional) expression, 306
CAST expression, 309
VARCHAR data type, 211
Variable-length character column, 211
VARIANCE function
DISTINCT clause within, 441
examples of, 442
statistical definition of, 441
syntax diagram of, 441
VARIANCE window function
examples of, 456
syntax diagram of, 455
Views
CREATE VIEW statement, 88
description of, 264
DROP VIEW statement, 102
relationship to tables, 262
updatability requirements, 90
W
WEEK function
syntax diagram of, 443
window functions
AVG , 447
considerations, 447
COUNT , 448
DENSE_RANK , 449
MAX , 450
MIN , 451
RANK , 452
ROW_NUMBER, 452
STDDEV, 453
SUM, 454
VARIANCE, 455
Y
YEAR function
examples of, 444
syntax diagram of, 444
Z
ZEROIFNULL function
syntax diagram of, 445
483