Selecting DMSII Items

The following script disables the cloning of two DMSII items in the data set named ORDER by setting the value of the active column to 0 in the corresponding DMS_ITEMS table entries.

File name: script.user_layout.order

update DMS_ITEMS set active=0
where dms_item_name = 'SPECIAL-ORDER-DATE' or
dms_item_name = 'SPECIAL-ORDER-AMOUNT'
and dataset_name = 'ORDER'

Multiple data sets can contain items with the same name. Adding the data set name to the WHERE clause ensures that you update only the items in question.

For more information, see Tips for More Efficient Cloning.