SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
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-255
Host variables, INSERT statement 2-258
HOUR function
examples of 8-83
syntax diagram of 8-83
I
Identifiers 6-56
IF statement
examples of 3-62
, 3-63
syntax diagram of 3-61
import utility 5-18
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-11
CREATE INDEX statement 2-80
description of 6-59
limits C-1
populating 2-85
INDEXJOIN 2-66
INDEX_ELIMINATION_LEVEL
default 10-69
INFER_CHARSET default 10-49
INFO DEFINE command
examples of 4-45
syntax diagram of 4-45
INFO operation 5-53
INITIALIZE SQL statement
authorization and availability
requirements 2-251
examples of 2-251
purpose of 2-251
syntax diagram of 2-251
INSERT access privilege 2-241, 2-317
INSERT function
examples of 8-84
syntax diagram of 8-84
INSERT statement
access options 2-256
compatible data types 2-259
considerations 2-257
DEFAULT values 2-256
lock modes 2-256
MXCI examples of 2-262
ORDER BY clause 2-255
query expression within 2-254
syntax diagram of 2-252
target column list 2-254
using host variables 2-258
VALUES specification within 2-258
INSERT statement (embedded)
C examples of 2-267
COBOL examples of 2-267
Insertable views 2-160
INSERT_VSBB default 10-75
INTEGER data type 6-35
INTERACTIVE_ACCESS default 10-79
INTERVAL data