Mapping SQL Expressions to Target Column

Instead of selecting a Source Column name to map to a non-Adabas Target Column, you can create a SQL function and place it in Source Column to map to a Target Column.

 

Example:  Enter (FIRST_NAME+MIDDLE_I+LAST_NAME) in the blank Source Column drop-down value to create FULL_NAME in the Target Column.

 

Note: Only non-aggregate SQL functions can be mapped to a Target Column.