Intelligent Enterprises of the 21st Century

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [Z]

labels

     compound statement or loops     compound statements or loops 2nd 3rd

LANGUAGE SQL clause 2nd 3rd 4th     CREATE FUNCTION statements

large objects (LOB) table spaceslarge objects (LOBs)

     direct I/O operations     secondary I/O operations

     VARCHAR or VARCHAR FOR BIT DATA data type alternatives

LARGE table space 2nd 3rdLarge-object (LOB) data types. [See LOBs] Learning Services, IBM 2nd 3rd 4th

LEAVE statements 2nd 3rd 4th 5th

     label of the compound statements or loops

Linux

    installing DB2 LUW         Development Center 2nd

LIST APPLICATIONS command 2nd 3rd

LIST TABLES command 2nd 3rd 4th     FOR ALL option

LIST TABLESPACE CONTAINERS command 2nd LIST TABLESPACES command 2nd

LOB (large objects) table spacesLOB locators

     definition

    WITH HOLD clauses

         COMMIT statements

         ROLLBACK statements

LOBs (large objects)

     direct I/O operations

     secondary I/O operations

     VARCHAR or VARCHAR FOR BIT DATA data type alternatives

LOBs (large-object) data types 2nd

lock database object

     definition 2nd

    WITH HOLD clauses

         COMMIT statements

         ROLLBACK statements LOCK TABLE statementslocks

     best practices

         iSeries         LUW 2nd

         zSeries 2nd

    conrolling

         in DB2 LUW 2nd 3rd 4th 5th 6th 7th 8th

    controlling

         in iSeries 2nd

         in zSeries 2nd 3rd     isolation levels 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th

     lock avoidance     lock modes 2nd

     ON ROLLBACK RETAIN LOCKSLOCKSIZE TABLE statements

     tables logical partition (LPAR)

LONG VARCHAR built-in data type

     WITH COMPARISONS clause LONG VARCHAR data type 2nd     temporary tables

LONG VARCHAR data types

     UDFs

LONG VARGRAPHIC built-in data type

     WITH COMPARISONS clause LONG VARGRAPHIC data type

     temporary tables

LONG VARGRAPHIC data types     UDFs

LOOP statement     not supported in inline SQL PL 2nd

LOOP statements 2nd 3rd 4thloop statements

     definition 2nd

     FOR 2nd 3rd 4th 5th

     LOOP 2nd 3rd

         with ITERATE statement 2nd 3rd

         with LEAVE statement 2nd

     REPEAT 2nd 3rd 4th

     WHILE 2nd 3rd 4th 5th 6th

LOOP statements

     with ITERATE statement 2nd 3rd

     with LEAVE statement 2nd

LOWER function

     string comparisons

LPAR (logical partition)

LTRIM functionLUW, DB2    clauses

         LANGUAGE SQL

     defining multiple procedures with same qualified name     invoking procedures with CLP

     overloaded UDFs