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

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-31
S
SQL value expression 6-41
SQLCODE, using ERROR command 1-35
SQLMP objects, logical names 6-14
SQLMX objects, logical names 6-13
SQLSTATE, in SQL/MX messages 1-35
SQL/MP aliases
ALTER SQLMP ALIAS statement 2-8
catalogs 10-58
CREATE SQLMP ALIAS
statement 2-73
description of 6-109
DROP SQLMP ALIAS statement 2-132
OBJECTS table 6-15
schemas 6-105
SQL/MP catalogs 6-3
SQL/MP considerations
access options 1-30
catalogs 6-3
collations 1-31
datetime literals data
inserting 6-69
selecting 6-28
embedded statements 3-1
INTERVAL data
inserting 6-73
selecting 6-33
NCHAR data
inserting 6-66, 6-67
selecting 6-25
reserved words 1-26, B-1
stored text 1-30
views 1-30
SQL/MP objects, define names 6-14
SQL/MX catalogs 6-3
SQL/MX data types, and SPJ
methods 2-63
SQL/MX extensions E-6
reserved words B-1
statements 1-32
SQRT function
examples of 9-152
syntax diagram of 9-152
STABLE access
description of 1-7
locking 10-54
SELECT statement 2-213
SQL/MP 1-7, 1-30
Standards
ANSI conformance 1-32
ANSI SQL E-1
character set support E-7
ISO E-2
SQL/MX extensions E-6
Statement atomicity
automatic 1-13
control query defaults 10-74
description of 1-13
implicit abort 1-13
Statements, SQL
ANSI compliant 1-32
interruption of 1-5
SQL/MX extensions 1-33
Statistics
clearing 2-267
DISPLAY STATISTICS command
example of 2-185, 4-24
syntax diagram 4-23
HISINTS SQL/MP table 10-87
Histogram attributes in
SYSTEM_DEFAULTS table 10-49
HISTOGRAMS_nodename table 10-83
HISTOGRAM_INTERVALS table 10-85
HISTOGRM table 10-86
LS command 4-51
query cache 4-19
query plan 4-21
QUERYCACHE function 9-116
QUERYCACHEENTRIES
function 9-120