SQL$HELP72.HLB  —  DECLARE  MODULE  Arguments  VIEW_UPDATE_RULES
    Specifies whether or not the SQL module processor applies the
    ANSI/ISO SQL standard for updatable views to all views created
    during compilation.

    If you specify SQL99, SQL92, SQL89, or MIA, the SQL module
    processor applies that ANSI/ISO SQL standard for updatable views
    to all views created during compilation. Views that do not comply
    with the specified ANSI/ISO SQL standard for updatable views
    cannot be updated.

    The specified ANSI/ISO standard for updatable views requires the
    following conditions to be met in the SELECT statement:

    o  The DISTINCT keyword is not specified.

    o  Only column names can appear in the select list. Each column
       name can appear only once. Functions and expressions such as
       max(column_name) or column_name +1 cannot appear in the select
       list.

    o  The FROM clause refers to only one table. This table must be
       either a base table or a derived table that can be updated.

    o  The WHERE clause does not contain a subquery.

    o  The GROUP BY clause is not specified.

    o  The HAVING clause is not specified.

    If you specify SQLV40, SQL does not apply the ANSI/ISO standard
    for updatable views. Instead, SQL considers views that meet the
    following conditions to be updatable:

    o  The DISTINCT keyword is not specified.

    o  The FROM clause refers to only one table. This table must be
       either a base table or a derived table that can be updated.

    o  The WHERE clause does not contain a subquery.

    o  The GROUP BY clause is not specified.

    o  The HAVING clause is not specified.
Close Help