SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-30
S
SET TRANSACTION statement
C examples of 2-292
COBOL examples of 2-292
MXCI examples of 2-292
syntax diagram of 2-288
transaction modes set by 2-289
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-12
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-163
syntax diagram of 9-163
SIGNAL SQLSTATE statement
considerations 2-293
syntax diagram of 2-293
Similarity checking
CONTROL TABLE statement 2-67
FIXUP operation 5-28
SIMILARITY_CHECK default 10-78
VERIFY operation 5-132
SIMILARITY_CHECK default 10-78
Simple table, in SELECT statement 2-252
SIN function
examples of 9-164
syntax diagram of 9-164
SINH function
examples of 9-164
syntax diagram of 9-164
SKIP CONFLICT
publish/subscribe 1-9
SELECT statement 2-257
SMALLINT data type 6-35
Sort, scratch files 10-76
SORT_MAX_HEAP_SIZE_MB
default 10-72
SPACE function
examples of 9-165
syntax diagram of 9-165
SQL descriptor area
allocating 3-6
deallocating 3-16
DESCRIBE statement use of 3-35
EXECUTE statement use of 2-171
OPEN statement use of 3-73
SET DESCRIPTOR statement use
of 3-79
specifying size 3-6
SQL statement names, specifying with
comment 2-225
SQL statements
ANSI compliant 1-33
interruption of 1-5