Db2 Tools

Expand all | Collapse all

RC/Migrator Support for as-generated-expression-clause

Jump to Best Answer
  • 1.  RC/Migrator Support for as-generated-expression-clause

    Posted 11-14-2019 12:29 PM
    ​DB2 11 added the feature of defining columns to be generated as an expression, which could include the data change operation, special registers, or session variables.  This enhances auditing capabilities to be able to track who and what updated a row.

    RC/Migrator does not currently support this feature.  However RC/Query does support it, and can correctly generate DDL for existing tables with these kinds of columns.  We need full support for these types of columns within the DB2 Tools products.

    Jeff Haekenkamp
    DB2 Technology Principal Engineer

  • 2.  RE: RC/Migrator Support for as-generated-expression-clause
    Best Answer

    Posted 03-20-2020 11:03 AM
    Hello Jeff - hope things are well your way despite the chaos going on with the virus.
    I am sorry you haven't received a reply yet, but it seems like you're looking for the relative new features where Db2 will save the SQL operation as well who did the operation. This has been requested by quite a few users and is expected to be available in a couple of months in r20 via a PTF.

    Steen Rasmussen