SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-17
I
HIST_DEFAULT_SEL_FOR_PRED_RANG
E default 10-53
HIST_JOIN_CARD_LOWBOUND
default 10-53
HIST_NO_STATS_REFRESH_INTERVAL
default 10-54
HIST_NO_STATS_ROWCOUNT
default 10-54
HIST_NO_STATS_UEC default 10-54
HIST_PREFETCH default 10-54
HIST_ROWCOUNT_REQUIRING_STATS
default 10-55
HIST_SAME_TABLE_PRED_REDUCTION
default 10-55
HIST_SCRATCH_VOL default 10-55
HIST_SECURITY_WARNINGS
default 10-56
Host variable arrays, INSERT
statement 2-212
Host variables, INSERT statement 2-215
HOUR function
examples of 9-78
syntax diagram of 9-78
I
Identifiers 6-56
IF statement
examples of 3-62
, 3-63
syntax diagram of 3-61
import utility 5-36
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-71
description of 6-59
limits C-1
POPULATE INDEX utility 5-117
populating 2-76
INDEXJOIN 2-57
INDEX_ELIMINATION_LEVEL
default 10-68
INFER_CHARSET default 10-49
INFO DEFINE command
examples of 4-45
syntax diagram of 4-45
INFO operation 5-70
INITIALIZE SQL statement
authorization and availability
requirements 2-208
examples of 2-208
purpose of 2-208
syntax diagram of 2-208
INSERT access privilege 2-198, 2-231
INSERT function
examples of 9-79
syntax diagram of 9-79
INSERT statement
access options 2-213
compatible data types 2-216
considerations 2-214
DEFAULT values 2-213
lock modes 2-213
MXCI examples of 2-218
ORDER BY clause 2-212
query expression within 2-211
syntax diagram of 2-209
target column list 2-211
using host variables 2-215
VALUES specification within 2-215
INSERT statement (embedded)
C examples of 2-220
COBOL examples of 2-220
Insertable views 2-146
INSERT_VSBB default 10-74
INTEGER data type 6-35
INTERACTIVE_ACCESS default 10-78