SQL$HELP_OLD72.HLB  —  SET_VIEW_UPDATE_RULES, Arguments  SQLV40
    Specifies that the ANSI/ISO SQL standard for updatable views is
    not applied.

    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.

    The default is SQLV40.
Close Help