Modifying the data model by extending tables

You can use pluggable SQL to extend tables in the data model.

Procedure

  1. Update the column metadata table CDDWLCOLUMNTP to include metadata changes corresponding to any added, updated, or deleted columns.
  2. Update the dwlcollumn_tp_cd column in the V_ELEMENT table to point to the correct column code.
  3. Regenerate the corresponding pluggable SQL using the applicable administration services.