ODBC Server Reference Manual

HP NonStop ODBC Server Reference Manual—429151-002
Index-1
Index
A
Access mode
See Locking mode
Activities, client 2-11
ADD ALIAS statement 7-42
ADD CONTROLstatement 7-46
ADD DEFINE statement 7-49
ADD GOVERNING statement 7-75
ADD INDEX statement 7-50
ADD NET_SERVICE statement 7-53
ADD PROCEDURE statement 7-59
ADD PROCEDURE_COLUMNS
statement 7-61
ADD PROFILE statement 7-66
ADD SCFG statement 7-103
ADD SCS statement 7-93
ADD SERVERCLASS statement 7-81
ADD SMAP statement 7-89
ADD TABLE statement 7-105
ADD TRACE statement 7-109
ADD UMAP statement 7-112
ADD VIEW statement 7-119
Address, network 2-15
Aggregates
data type of the results 3-27, 4-31
support of 1-7, 1-9, 3-27, 4-31, A-1,
B-2
Alias
See Correlation names
ALIAS statement 7-41
Alias username 2-19
ALL clause 3-56, 4-85
ALL operator 3-26
ALTER CATALOG statement, in pass-
through mode 6-8
ALTER INDEX statement, in pass-through
mode 6-8
ALTER PROGRAM statement, in pass-
through mode 6-8
ALTER TABLE statement
adding multiple columns with 3-34,
4-43
in pass-through mode 6-8, 6-17, 6-18
in user-defined transactions 4-3
syntax 3-33, 4-42
ALTER VIEW statement, in pass-through
mode 6-9
AND operator 3-26
ANY operator 3-26
Application program interface (API)
for SQL on HP NonStop server 2-3
ODBC as 1-1
Architecture, NonStop ODBC Server 2-1
Audited tables 4-43, 4-56, 4-70
AVG function 3-27, 4-31
B
Batch queries, support of 4-4, B-2
BEGIN TRANSACTION statement 4-45
BEGIN WORK statement
See BEGIN TRANSACTION statement
BEGIN...END statement 4-44
BETWEEN operator 3-26
Blanks, trailing 4-31, 4-34
Boolean expressions 3-26, 4-29
Break handling 5-58
BROWSE MODE, support of B-3
C
Caching NonStop SQL compilations 2-41
CALL statement 3-35
Call-level interface (CLI) 1-1
CASE expression 3-29
Case sensitivity
and character comparisons 3-29, 4-31,
4-34
and names 3-4, 4-7, A-6, B-9