SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-30
S
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-35
EXECUTE statement use of 2-139
OPEN statement use of 3-73
SET DESCRIPTOR statement use
of 3-79
specifying size 3-6
SQL statement names, specifying with
comment 2-183
SQL statements
ANSI compliant 1-32
interruption of 1-5
SQL/MX extensions 1-33
SQL value expression 6-38
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-52
CREATE SQLMP ALIAS
statement 2-75
description of 6-106
DROP SQLMP ALIAS statement 2-131
OBJECTS table 6-15
schemas 6-102
SQL/MP catalogs 6-3
SQL/MP considerations
access options 1-30
catalogs 6-3
collations 1-31
datetime literals data
inserting 6-66
selecting 6-26
SQL/MP considerations (continued)
embedded statements 3-1
INTERVAL data
inserting 6-70
selecting 6-31
metadata 10-2
NCHAR data
inserting 6-63, 6-64
selecting 6-23
reserved words 1-26, B-1
stored text 1-30
views 1-30
SQL/MP metadata 10-2
SQL/MP objects, define names 6-14
SQL/MX catalogs 6-3
SQL/MX data types, and SPJ
methods 2-65
SQL/MX extensions E-6
reserved words B-1
statements 1-32
SQRT function
examples of 9-145
syntax diagram of 9-145
STABLE access
description of 1-7
locking 10-48
SELECT statement 2-212
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-69
description of 1-13
implicit abort 1-13