SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-17
I
HIST_DEFAULT_SEL_FOR_LIKE_WILDC
ARD default 10-54
HIST_DEFAULT_SEL_FOR_PRED_RANG
E default 10-54
HIST_JOIN_CARD_LOWBOUND
default 10-54
HIST_NO_STATS_REFRESH_INTERVAL
default 10-55
HIST_NO_STATS_ROWCOUNT
default 10-55
HIST_NO_STATS_UEC default 10-55
HIST_PREFETCH default 10-55
HIST_ROWCOUNT_REQUIRING_STATS
default 10-56
HIST_SAME_TABLE_PRED_REDUCTION
default 10-56
HIST_SCRATCH_VOL default 10-56
HIST_SECURITY_WARNINGS
default 10-57
Host variable arrays, INSERT
statement 2-220
Host variables, INSERT statement 2-223
HOUR function
examples of 9-83
syntax diagram of 9-83
I
Identifiers 6-56
IF statement
examples of 3-62
, 3-63
syntax diagram of 3-61
import utility 5-42
IN predicate
examples of 6-96
limits C-1
logical equivalent using ANY 6-95
operand requirements 6-95
syntax diagram of 6-94
Index keys 6-62
Indexes
ALTER INDEX statement 2-8
CREATE INDEX statement 2-72
description of 6-59
limits C-1
POPULATE INDEX utility 5-127
populating 2-77
INDEXJOIN 2-58
INDEX_ELIMINATION_LEVEL
default 10-71
INFER_CHARSET default 10-50
INFO DEFINE command
examples of 4-45
syntax diagram of 4-45
INFO operation 5-77
INITIALIZE SQL statement
authorization and availability
requirements 2-216
examples of 2-216
purpose of 2-216
syntax diagram of 2-216
INSERT access privilege 2-206, 2-243
INSERT function
examples of 9-84
syntax diagram of 9-84
INSERT statement
access options 2-221
compatible data types 2-224
considerations 2-222
DEFAULT values 2-221
lock modes 2-221
MXCI examples of 2-227
ORDER BY clause 2-220
query expression within 2-219
syntax diagram of 2-217
target column list 2-219
using host variables 2-223
VALUES specification within 2-223
INSERT statement (embedded)
C examples of 2-232
COBOL examples of 2-232
Insertable views 2-148
INSERT_VSBB default 10-77