SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-30
S
SET TRANSACTION
statement (continued)
syntax diagram of 2-244
transaction modes set by 2-245
SET WARNINGS command
examples of 4-70
syntax diagram of 4-70
SH command
examples of 4-71
syntax diagram of 4-71
SHARE lock mode 1-11
Shorthand view 6-113
SHOW PARAM command
examples of 4-72
syntax diagram of 4-72
SHOW PREPARED command
examples of 4-73
syntax diagram of 4-73
SHOW SESSION command
attributes displayed by 4-74
examples of 4-75
syntax diagram of 4-74
SHOWCONTROL command
examples of 4-77
syntax diagram of 4-76
SHOWDDL command
examples of 4-87
syntax diagram of 4-82
SHOWLABEL command
examples of 4-98
syntax diagram of 4-95
SHOWSHAPE command
default CQS 4-106
examples of 4-106
syntax diagram of 4-106
SIGN function
examples of 9-150
syntax diagram of 9-150
SIGNAL SQLSTATE statement
considerations 2-249
SIGNAL SQLSTATE statement (continued)
syntax diagram of 2-249
Similarity checking
CONTROL TABLE statement 2-50
FIXUP operation 5-24
SIMILARITY_CHECK default 10-75
VERIFY operation 5-125
SIMILARITY_CHECK default 10-75
Simple table, in SELECT statement 2-208
SIN function
examples of 9-151
syntax diagram of 9-151
SINH function
examples of 9-151
syntax diagram of 9-151
SKIP CONFLICT
publish/subscribe 1-8
SELECT statement 2-213
SMALLINT data type 6-35
Sort, scratch files 10-73
SORT_MAX_HEAP_SIZE_MB
default 10-69
SPACE function
examples of 9-152
syntax diagram of 9-152
SQL descriptor area
allocating 3-6
deallocating 3-16
DESCRIBE statement use of 3-35
EXECUTE statement use of 2-140
OPEN statement use of 3-73
SET DESCRIPTOR statement use
of 3-79
specifying size 3-6
SQL statement names, specifying with
comment 2-184
SQL statements
ANSI compliant 1-32
interruption of 1-5
SQL/MX extensions 1-33