SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-22
F
FILETYPE, in FILES table F-27
File, formats, Enscribe Q-4
File-system errors D-21
Filler characters, overflow O-10
FIRST KEY clause
ALTER INDEX statement A-18
ALTER TABLE statement A-37
defaults for unspecified columns P-17
First key, size limit L-8
FIRST option
COPY command C-116
LOAD command L-21
FIRSTKEY, in PARTNS table P-20
Fixing command F-1
FLOAT data syntax D-5
FOLD option, COPY command C-119
Folding a line L-53
Footing
See PAGE FOOTING command
Footings
break B-6
page P-1
report R-2
FOR PROTECTION clause, CREATE VIEW
statement C-168
FOR UPDATE OF clause
DECLARE CURSOR statement D-23
SELECT statement S-24
Forced page break D-49
FORCE, in PROGRAMS table P-32
FOREIGN KEY table constraint S-68
Form feeds for reports P-3
Form name for reports O-9
Format
dates and times C-174
Enscribe files Q-4
file F-30
print item A-60
type A-25
Format 2 partitions
description of F-30
EXTENT sizes E-30
FORMAT file attribute F-30
limits L-9
MAXEXTENTS M-2
migration A-46
PARTITION clause P-16
Format 2-enabled
indexes A-25, C-149
Format 2-enabled tables
command C-156
example C-163, C-165
partition A-47
partition array A-33, A-45, C-159
partition array parameter C-162
partition formats C-161
FORMAT file attribute F-30
Formatting commands
See also Report
FORTRAN data types, converting to
SQL C-105, S-69
FREE RESOURCES statement
and COMMIT WORK statement C-57
and ROLLBACK WORK
statement R-22
description of F-30
lock realease summary L-48
lock release summary L-48
FROM clause
limit on tables L-8
SELECT statement S-20
FSDATATYPE in COLUMNS table C-46
Functions
aggregate A-6, F-32
AVG A-76
CAST C-4
CHAR_LENGTH C-20
COMPUTE_TIMESTAMP C-62
CONVERTTIMESTAMP C-113