Cloning a Numeric Field as a Date

The following script causes the define command to map a DMSII item of type NUMBER(8) to a relational database date data type where the number contains a date in the mmddyyyy format.

File name: script.user_layout.payments

update DMS_ITEMS set dms_subtype=23,di_options=2
where dms_item_name = 'PAYMENT-DATE' and dataset_name='PAYMENTS'