Neoview SQL Reference Manual (R2.4)

examples of, 186
syntax diagram of, 185
SET TRANSACTION statement
considerations for, 189
description of, 188
examples of, 191
syntax diagram of, 187
transaction modes set by, 188
SHARE lock mode, 29
SHOWDDL statement, 192
considerations for, 192
differences between output and original DDL, 192
examples of, 193
privileges option, 193
syntax diagram of, 192
SIGN function
examples of, 447
syntax diagram of, 447
Simple table, in SELECT statement, 168
SIN function
examples of, 448
syntax diagram of, 448
SINH function
examples of, 449
syntax diagram of, 449
SKIP CONFLICT
publish/subscribe, 29
SELECT statement, 171
SMALLINT data type, 239
SPACE function
examples of, 450
syntax diagram of, 450
SQL statements
ANSI compliant, 35
Neoview SQL extensions, 36
SQL Utilities
MAINTAIN command, 210
POPULATE INDEX utility, 218
privileges, 209
PURGEDATA utility, 219
SQL value expression, 240
SQRT function
examples of, 451
syntax diagram of, 451
Standards
ANSI SQL, 507
character set support, 511
ISO, 507
Statement atomicity
automatic, 30
description of, 30
Statements, SQL
ANSI compliant, 35
Neoview SQL extensions, 36
Statistics
clearing, 202
UPDATE STATISTICS statement
considerations, 205
examples of, 206
STDDEV function
DISTINCT clause within, 452
examples of, 453
statistical definition of, 452
syntax diagram of, 452
STDDEV window function
examples of, 494
syntax diagram of, 494
Stored procedure statements, 41
CALL, 55
GRANT EXECUTE, 135
REVOKE EXECUTE, 156
Stored text
reserved words, 501
Stream timeout
dynamic, SET TABLE TIMEOUT statement setting,
185
String literals, 256
String value expression
examples of, 241
syntax diagram of, 240
Subquery
correlated, 272, 289
description of, 288
inner query, 288
outer query, 288
outer reference, 289
row
BETWEEN predicate, 267
comparison predicate, 269
IN predicate, 273
NULL predicate, 277
quantified comparison predicate, 279
scalar
BETWEEN predicate , 267
comparison predicate , 269
DELETE statement, 106, 197
IN predicate , 273
NULL predicate, 277
quantified comparison predicate, 279
UPDATE statement, 197
table, 273
SUBSTR function
examples of, 455
operand requirements, 454
syntax diagram of, 454
SUBSTRING function
examples of, 455
operand requirements, 454
syntax diagram of, 454
Suitable keys
Neoview SQL guidelines for selecting, 78
SUM function
DISTINCT clause within, 456
examples of, 456
syntax diagram of, 456
SUM window function
examples of, 495
syntax diagram of, 495
527