Neoview SQL Reference Manual (R2.4 SP2)

Roles, 25
Rollback mode
norollback-option, 188
ROLLBACK WORK statement
considerations for, 162
example of, 162
syntax diagram of, 162
ROUND function
examples of, 438
syntax diagram of, 438
Row size, calculating, 86
Row value constructor
BETWEEN predicate use of, 273
comparison predicates use of, 275
IN predicate use of, 279
NULL predicate use of, 283
quantified comparison predicates use of, 284
ROW_NUMBER window function
examples of, 491
syntax diagram of, 491
ROWS SINCE CHANGED function
considerations for, 441
examples of, 441
syntax diagram of, 441
ROWS SINCE function
examples of, 439
syntax diagram of, 439
ROWS/REQUEST, 124
ROWS_OUT, 124
RPAD function
examples of, 442
syntax diagram of, 442
RTRIM function
examples of, 443
syntax diagram of, 443
RUNNINGAVG function
equivalent definition, 444
examples of, 444
syntax diagram of, 444
RUNNINGCOUNT function
examples of, 445
syntax diagram of, 445
RUNNINGMAX function
examples of, 446
syntax diagram of, 446
RUNNINGMIN function
examples of, 447
syntax diagram of, 447
RUNNINGSTDDEV function
equivalent definition, 448
examples of, 448
syntax diagram of, 448
RUNNINGSUM function
examples of, 449
syntax diagram of, 449
RUNNINGVARIANCE function
examples of, 450
syntax diagram of, 450
S
SAMPLE clause
cluster sampling, 308
examples of, 308
SELECT statement use of, 306
syntax diagram of, 306
Sampling, clusters, 308
Scale, 254
Schemas
description of, 291
reserved for HP, 70
Search condition
Boolean operators within, 292
CASE expression use of, 342
DELETE statement use of, 107
description of, 294
examples of, 293
predicate within, 292
syntax diagram of, 292
UPDATE statement use of, 199
SECOND function
examples of, 451
syntax diagram of, 451
SELECT statement
access options, 171
authorization requirements, 172
considerations for, 172
DISTINCT clause , 165
embedded delete, 167
embedded insert, 168
embedded update, 167, 168
examples of, 177
FROM clause , 166
GROUP BY clause , 170, 174
HAVING clause, 171
joined table within, 168
limit on join tables, 173
lock modes, 171
ORDER BY clause , 172, 175
RETURN list, 167
select list elements, 165
SEQUENCE BY clause, 170
simple table within, 169
SKIP CONFLICT access, 171
stream access limitations, 173
STREAM clause, 166
syntax diagram of, 163
TRANSPOSE clause, 170
UNION ALL operation, 176
union operation within, 171, 175
updating rows, 172
views and, 173
WHERE clause, 169
Self-referencing INSERT, 144
SEQUENCE BY clause
examples of, 315
SELECT statement use of, 314
syntax diagram of, 314
Sequence functions
534 Index