Cloning an Alpha Field as a Date

The following script causes the define command to map three DMSII items of type ALPHA(10) to a relational database date data type, where those items contain a date in the mm/dd/yyyy format.

File name: script.user_layout.order

update DMS_ITEMS set dms_subtype=53,di_options=2
where dms_item_name = 'ORDER-DATE' or
dms_item_name = 'DUE-DATE' or
dms_item_name = 'DATE-SENT'
and dataset_name='ORDER'