SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-27
L
LAYOUT option, SAVE command S-3
LC_COLLATE section C-32
LC_CTYPE section C-35
LC_TDMCODESET section C-37
Left justification A-61, A-63, A-64, A-65
LEFT OUTER JOIN operator S-70
Left outer joins J-1
LEFT_MARGIN layout option L-1, R-10
Length of page P-2
Levels of index, displaying F-19
Licensing F-35
LIKE clause, CREATE TABLE
statement C-155
LIKE predicate L-2
Limits on concurrency C-68, L-6
Lines
folding L-53
new line character N-4
number on page P-2
resetting number of L-14
skipping in report D-49
spacing L-16
splitting L-53
truncating or wrapping S-42
LINE_NUMBER function L-14, R-11
LINE_NUMBER, default display
format L-15
LINE_SPACING layout option L-16, R-10
LIST command L-16
LISTALL option
DUP command D-72
PURGE command P-34
PURGEDATA command P-37
SECURE command S-9
LIST_COUNT option
RESET SESSION command R-19
SET SESSION command S-41
Literals
DATE D-11
DATETIME D-11
date-time D-10
Literals (continued)
description of L-18
INTERVAL I-22
numeric N-13
string S-80
TIME D-11
TIMESTAMP D-11
LOAD command
and AUDIT attribute L-18, L-34
authorization requirements L-33
compared to APPEND A-55
compared to COPY L-33
conversion and loading errors L-37,
L-38
description of L-18
examples of L-45
field conversion L-36
field formats L-36
operations L-33
TMF and L-18, L-33
using tapes with L-34
LOAD command options
ALLOWERRORS L-20
BLOCKIN L-24
COMPACT L-24
EBCDICIN L-24
FIRST L-21
MOVEBYNAME L-30
MOVEBYORDER L-31
RECIN L-25
REDEFINE L-31
REELS L-26
REPLACE SPACES WITH
ZEROES L-22
REWINDIN L-26
SHARE L-26
SKIPIN L-26
SOURCEDICT L-29
SQLNULLABLE L-23
TARGETDICT L-30