SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-26
J
IXPART01
catalog table, limits L-10, L-11
file C-9
IXPROG01 file C-9
IXTABL01 file C-9
IXUSAG01 file C-9
I/O (input/output)
serial or parallel writes S-32
verify disk writes V-1
J
JIS X0208 (Japanese) character set C-18
JOIN METHOD option, CONTROL TABLE
directive C-80
Join queries J-1
JOIN SEQUENCE option, CONTROL
TABLE directive C-81
Joins
controlling C-86
description of J-1
example of S-30
inner J-1, J-2
left outer J-1
SELECT specification S-20
Julian timestamp
and COMPUTE_TIMESTAMP C-62
formatting A-60
JULIANTIMESTAMP function J-4
Justification A-61, A-63, A-64, A-65, A-66
K
Kanji character set C-18
KEY clause
CLUSTERING, CREATE TABLE
statement C-157
PRIMARY, CREATE TABLE
statement C-157
KEY option, LOAD command L-21
Keys
clustering C-28
Keys (continued)
column length F-17
description of K-1
displaying F-17
first, specifying value of A-18, A-37
for indexes I-9
INDEX I-9
maximum values L-13
nonunique primary C-28
physical primary P-27
primary P-27, S-90
system-defined primary S-90
user-defined primary U-16
KEYS catalog table K-1
Keys specifier
description of C-145
displaying F-17
KEYSEQNUMBER, in KEYS table K-1
KEYTAG clause, CREATE INDEX
statement C-145
Keytags I-9
KEYTAG, in INDEXES table I-10
Key-sequenced block size B-5
Key-sequenced files F-8
Key-sequenced tables S-90
KSC5601 (Korean) character set C-19
L
Labels
for subtotal S-88
Language
displaying using ENV command E-3
elements H-2
LARGEINT data syntax D-5
Layout options
default R-13
displaying S-50
resetting R-13
saving in file S-2
setting S-34