Sample Data Set Selection Script

This script selects the data sets that we want to clone. Following is a sample user script for a DMSII customer database whose data source name is CMDB. This script turns cloning off (by setting the active column value to 0) for two data sets.

File name: script.user_datasets.cmdb

update DATASETS set active = 0
where data_source = ' CMDB'

/***/

update DATASETS set active = 0 /
where dataset_name = 'CAT' and data_source='CMDB'

/***/

update DATASETS set active = 0
where dataset_name = 'DOG' and data_source='CMDB'

/***/

update DATASETS set active = 0
where dataset_name = 'SKUNK' and data_source='CMDB'

***/

update DATASETS set active = 0
where dataset_name = 'RACOON' and data_source='CMDB'

For a complete explanation of specifying data sets for cloning, see Tips for More Efficient Cloning.