NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-28
L
PURGE command P-33
PURGEDATA command P-37
SECURE command S-9
LIST_COUNT option
RESET SESSION command R-21
SET SESSION command S-41
Literals
DATE D-10
DATETIME D-10
date-time D-9
description of L-17
INTERVAL I-22
numeric N-13
string S-78
TIME D-10
TIMESTAMP D-10
LOAD command
and AUDIT attribute L-17
, L-33
authorization requirements L-31
compared to APPEND A-50
compared to COPY L-32
conversion and loading errors L-37
description of L-17
examples of L-41
field conversion L-36
field formats L-35
move options L-29, L-35
operations L-31
options
ALLOWERRORS L-20
BLOCKIN L-23
COMPACT L-23
EBCDICIN L-23
FIRST L-21
MOVE L-29
MOVEBYNAME L-29
MOVEBYORDER L-29
RECIN L-24
REDEFINE L-30
REELS L-25
REPLACE SPACES WITH
ZEROES L-22
REWINDIN L-25
SHARE L-25
SKIPIN L-25
SOURCEDICT L-28
TARGETDICT L-28
TARGETREC L-28
TRIM L-25
TRUNC L-30
UNLOADIN L-26
UPSHIFT L-22
VA R IN L-26
TMF and L-17, L-33
using tapes L-33
LOAD option, CONVERT command C-93
Loading data, rules for tape use L-33
Local autonomy C-82
Local user, defined S-14
LOCK TABLE statement
and CONTROL TABLE directive L-42
description of L-41
EXCLUSIVE clause L-41
SHARE clause L-41
Lock waits, CONTROL TABLE
directive C-77
Locking L-44
LOCKLENGTH file attribute
description of L-48
displaying F-18
LOCKLENGTH, in FILES table F-28
Locks
access by cursors F-4
and FETCH F-4
control system chosen C-79
control timeout C-79
duration L-44
escalation L-46