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
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.