Use the DATAITEMS client control table to rename the columns that appear in the relational database. The data_item column shows the DMSII data item (column) name and the item_name column shows the name of the column as it will appear in the relational database. For an explanation of how the DMSII data set and data items are mapped to the relational database, see Relational Database Table and Column Names.
You can change one or more column names before or after cloning, as follows:
The following script changes the names of two columns in the table derived from the data set named ORDERS.
File name: script.user_define.orders
update DATAITEMS set item_name='order_amount'
update DATAITEMS set item_name='order_date'