SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-20
F
Examples, database used in S-1
Exclamation point command Z-1
EXCLUSIVE clause, LOCK TABLE
statement L-45
Exclusive locks
description of L-50
EXCLUSIVE clause L-45
on SELECT statement S-21
Execute access S-14
EXECUTE command
COMPUTE_TIMESTAMP
function C-62
CURRENT_TIMESTAMP
function C-174
EXECUTE IMMEDIATE statement E-11
EXECUTE statement
CURRENT_TIMESTAMP function E-8
description of E-7
RETURNING clause E-9
USING clause E-7
USING DESCRIPTOR clause E-7
Execution plans P-22
EXISTS predicate E-12
EXIT command E-13
Expiration date A-32, N-5
EXPLAIN directive E-13
Exploded record length F-16
Exponents N-13
Expressions
CASE C-2
character C-14
date-time E-22
date-time, evaluation E-25
description of E-21
INTERVAL E-22
numeric E-22
with date-time items E-25
EXTEND function E-28
EXTENT file attribute E-30
Extents
Available space in file or object F-19
Extents (continued)
MAXEXTENTS file attribute M-2
EXTENTS ALLOCATED display, FILEINFO
command F-19
EXTENTS display, FILEINFO
command F-21
EXTENTS option, FILEINFO
command F-10
F
FastSort Z-4
FC command, prompt S-60
FETCH statement
and cursors F-4
and SQLDA F-3
description of F-3
INTO clause F-3
lock realease summary L-48
lock release summary L-48
USING DESCRIPTOR clause F-3
Fetching rows F-3
Field conversion C-126, L-36
Field formats
and copying data C-126
and loading data L-36
File attributes
ALLOCATE A-7
ALTER INDEX statement A-15
ALTER TABLE statement A-32
AUDIT A-74
AUDITCOMPRESS A-75
BLOCKSIZE B-5
BUFFERED B-11
CLEARONPURGE C-26
CREATE INDEX statement C-146
CREATE TABLE statement C-160
DCOMPRESS D-18
DEALLOCATE A-7
description of F-6
displaying F-18