SQL$HELP72.HLB  —  SET_VIEW_UPDATE_RULES, Arguments  SQL99 or SQL92
    Specifies that the ANSI/ISO standard for updatable views is
    applied to all views created during compilation. Views that do
    not comply with the ANSI standard for updatable views cannot be
    updated.

    The 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.
Close Help