Understanding DB2: Learning Visually with Examples (2nd Edition)

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] [X] [Z]

Query

query optimization class Query optimizerQuerying data    % (percent sign), wildcard [See modifying, Updating;data, search, SQL]    _ (underline), wildcard [See modifying, Updating;data, search, SQL]

    BETWEEN predicate [See modifying, Updating;data, search, SQL]

    CASE expression [See modifying, Updating;data, search, SQL]    case study [See modifying, Updating;data, search, SQL]    CAST expression [See modifying, Updating;data, search, SQL]

    casting data types [See modifying, Updating;data, search, SQL]    COALESCE function [See modifying, Updating;data, search, SQL]    column functions [See modifying, Updating;data, search, SQL]

    columns

        combining [See modifying, Updating;data, search, SQL]

        derived [See modifying, Updating;data, search, SQL]

        intersecting values [See modifying, Updating;data, search, SQL]    CTE (common table expression) [See modifying, Updating;data, search, SQL]

    current date and time [See modifying, Updating;data, search, SQL]

    EXCEPT ALL operator [See modifying, Updating;data, search, SQL]    EXCEPT operator [See modifying, Updating;data, search, SQL]    FETCH FIRST n ROWS ONLY clause [See modifying, Updating;data, search, SQL]    FULLOUTERJOIN keyword [See modifying, Updating;data, search, SQL]

    GROUP BY...HAVING clause [See modifying, Updating;data, search, SQL]

    hierarchical data [See modifying, Updating;data, search, SQL]

    IN predicate [See modifying, Updating;data, search, SQL]

    inner joins [See modifying, Updating;data, search, SQL]

    INNERJOIN keyword [See modifying, Updating;data, search, SQL]

    INTERSECT ALL operator [See modifying, Updating;data, search, SQL]

    INTERSECT operator [See modifying, Updating;data, search, SQL]

    intersections [See modifying, Updating;data, search, SQL]

    isolation level [See modifying, Updating;data, search, SQL]

    joining tables [See modifying, Updating;data, search, SQL]

    LEFTOUTERJOIN keyword [See modifying, Updating;data, search, SQL]

    LIKE predicate [See modifying, Updating;data, search, SQL]

    lockout time [See modifying, Updating;data, search, SQL]

    NULLS [See modifying, Updating;data, search, SQL]

    ORDER BY clause [See modifying, Updating;data, search, SQL]

    OVER function [See modifying, Updating;data, search, SQL]    package paths [See modifying, Updating;data, search, SQL]    pattern searches [See modifying, Updating;data, search, SQL]

    recursive SQL [See modifying, Updating;data, search, SQL]

    result sets, row counts [See modifying, Updating;data, search, SQL]    RIGHTOUTERJOIN keyword [See modifying, Updating;data, search, SQL]

    ROWNUMBER function [See modifying, Updating;data, search, SQL]

    rows        counting in result sets [See modifying, Updating;data, search, SQL]

        eliminating duplicates [See modifying, Updating;data, search, SQL]        grouping [See modifying, Updating;data, search, SQL]

    rows, retrieving        adding to result sets [See modifying, Updating;data, search, SQL]        between specified values [See modifying, Updating;data, search, SQL]        by distinct values [See modifying, Updating;data, search, SQL]        by specified values [See modifying, Updating;data, search, SQL]

        first n [See modifying, Updating;data, search, SQL]

        higher than n [See modifying, Updating;data, search, SQL]        in specified order [See modifying, Updating;data, search, SQL]        maximum of n [See modifying, Updating;data, search, SQL]

    scalar functions [See modifying, Updating;data, search, SQL]    schema names [See modifying, Updating;data, search, SQL]    SELECT COUNT DISTINCT statement [See modifying, Updating;data, search, SQL]

    SELECT COUNT statement [See modifying, Updating;data, search, SQL]

    SELECT DISTINCT statement [See modifying, Updating;data, search, SQL]

    SELECT statement examples [See modifying, Updating;data, search, SQL]

    selective processing [See modifying, Updating;data, search, SQL]    special registers [See modifying, Updating;data, search, SQL]

    timestamps [See modifying, Updating;data, search, SQL]

    UNION operator [See modifying, Updating;data, search, SQL]    UNIONALL operator [See modifying, Updating;data, search, SQL]    unions [See modifying, Updating;data, search, SQL]    user authorization [See modifying, Updating;data, search, SQL]

    WHERE clause [See modifying, Updating;data, search, SQL]

Querying, load information

Question mark (?), help request 2nd 3rd 4th

Quiesce

Quiesce points

quiesce tablespaces for table command

QUIESCE_CONNECT authority 2nd

Quiescing table spaces