Db2 Tools

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

  • 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
    ------------------------------