VMS Help  —  SQLMOD72  Arguments  VIEW_UPDATE_RULES
    Specifies whether or not the SQL module processor applies the
    ANSI/ISO standard for updatable views to all views created during
    compilation.

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

    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.

    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 view that can be updated.

    o  The GROUP BY clause is not specified.

    o  The HAVING clause is not specified.
Close Help