Q


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 optimizer
Querying 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



Understanding DB2(R. Learning Visually with Examples)
Understanding DB2: Learning Visually with Examples (2nd Edition)
ISBN: 0131580183
EAN: 2147483647
Year: 2004
Pages: 313

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net