Defining Transforms on Columns

A transform is used to 'transform' (or convert) an existing data item value to and/or from a relational database column value. Transforms can be applied to the data item in the FD or at the column level (as described here).

Transforms applied at FD level affect all table definitions containing the data item the transform is applied to. Transforms applied at the column level only affects that column, in that table definition.

CAUTION:

If a transform is set at both FD level and column level, it is first transformed using the FD level transformation, and then again using the column level transformation, which may produce undesired results.

In the Catalog window, double-click the Tables node.
The catalog's table definitions are displayed.
Double-click the required table definition.
The table definition is displayed, showing the current table columns.
Select the required column.
The column properties are displayed in the right-hand Properties pane.
In the Properties pane, click next to Column Transform and select the required transform.

Note: The list of available transforms is based on the column's data type. It may be necessary to change the Data Type property for the column to make the desired transform available.
Click Save to Catalog.