Changing SQL Data Types

The following user script changes the sql_type for a packed decimal (sql_type of 11) data item named order_amount to be a floating point number (sql_type of 6).

File name: script.user_define.transaction

update DATAITEMS set sql_type=6
where item_name='order_amount' and table_name='orders'