RDOHELP72.HLB  —  Logical Names, RDMS$USE_OLD_UPDATE_RULES
    This section discusses use of the RDMS$USE_OLD_UPDATE_RULES
    logical name to preserve update behavior. You cannot modify or
    erase records in a relation if the relation is joined with other
    relations.

                                   NOTE

       This restriction applies to RDO, RDBPRE, and RDML only. SQL
       syntax does not allow this type of update.

    However, updates to a relation are allowed if you join the
    relation with other relations in a subquery.

    This update restriction can cause applications that depend on
    the previous update behavior to fail unless update queries are
    modified. You can use the RDMS$USE_OLD_UPDATE_RULES logical
    name to retain the previous update behavior, then modify your
    applications.

    Define the RDMS$USE_OLD_UPDATE_RULES logical name to be 1, as
    shown below, to enforce the old update rules.

    $ DEFINE RDMS$USE_OLD_UPDATE_RULES 1

    Support for this logical name will be removed in a future release
    of Oracle Rdb.
Close Help