SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-28
S
SET WARNINGS command
examples of 4-55
syntax diagram of 4-55
SH command
examples of 4-56
syntax diagram of 4-56
SHARE lock mode 1-10
Shorthand view 6-112
SHOW PARAM command
examples of 4-57
syntax diagram of 4-57
SHOW PREPARED command
examples of 4-58
syntax diagram of 4-58
SHOW SESSION command
attributes displayed by 4-59
examples of 4-60
syntax diagram of 4-59
SHOWCONTROL command
examples of 4-62
syntax diagram of 4-61
SHOWDDL command
examples of 4-71
syntax diagram of 4-67
SHOWLABEL command
examples of 4-81
syntax diagram of 4-78
SHOWSHAPE command
default CQS 4-89
examples of 4-89
syntax diagram of 4-89
SIGN function
examples of 9-142
syntax diagram of 9-142
SIGNAL SQLSTATE statement
considerations 2-227
syntax diagram of 2-227
Similarity checking
CONTROL TABLE statement 2-50
FIXUP operation 5-14
Similarity checking (continued)
SIMILARITY_CHECK default 10-63
VERIFY operation 5-79
SIMILARITY_CHECK default 10-63
Simple table, in SELECT statement 2-188
SIN function
examples of 9-143
syntax diagram of 9-143
SINH function
examples of 9-144
syntax diagram of 9-144
SKIP CONFLICT
publish/subscribe 1-8
SELECT statement 2-193
SMALLINT data type 6-34
Sort, scratch files 10-61
SPACE function
examples of 9-145
syntax diagram of 9-145
SQL descriptor area
allocating 3-6
deallocating 3-16
DESCRIBE statement use of 3-34
EXECUTE statement use of 2-136
OPEN statement use of 3-74
SET DESCRIPTOR statement use
of 3-80
specifying size 3-6
SQL statement names, specifying with
comment 2-164
SQL statements
ANSI compliant 1-31
interruption of 1-4
SQL/MX extensions 1-32
SQL value expression 6-39
SQLCODE, using ERROR command 1-34
SQLMP objects, logical names 6-13
SQLMX objects, logical names 6-12
SQLSTATE, in SQL/MX messages 1-34