Modifying the data model by extending tables
You can use pluggable SQL to extend tables in the data model.
Procedure
- Update the column metadata table CDDWLCOLUMNTP to include metadata changes corresponding to any added, updated, or deleted columns.
- Update the
dwlcollumn_tp_cd
column in the V_ELEMENT table to point to the correct column code. - Regenerate the corresponding pluggable SQL using the applicable administration services.