DB2 9 Fundamentals: Certification Study Guide

Failover, 11

FAT clients, 13

Fault monitoring, 11

Federated databases, 9, 11, 121

Homogeneous Federation Feature in, 39–40, 42

FENCED, 237

Fenced UDFs, 113

FETCH

Cursor Stability isolation level and, 468, 469, 472–473, 474, 476, 610, 612, 613

cursors and, 318, 319–320, 322

FETCH FIRST, 268, 271, 287–288, 588–589

Fields, tables and, 196

First Steps, 53

Fixed-length character string (CHARACTER, CHAR), 368

Fixed-length double-byte character string (GRAPHIC), 199, 369, 455, 600

FLOAT, 199, 367–368, 600

Flows, 14

FOR BIT DATA option, 200

FOR FETCH ONLY clause, 317

FOR READ ONLY clause, 317

FOR UPDATE OF clause, 317

Foreign key, 606

referential integrity constraints and, 382, 384t, 459

Foreign key constraints, 381

Formats for date/time data types, 371t

FROM clause, 267–268, 271, 291, 331, 363, 598

Fulfillment ID, 34

Full outer joins, 301, 303, 303, 305. See also outer joins

Functions, 586

user-defined. See user-defined functions, 228