Defining Candidate Data Set Criteria

The lower panel of the Mass Change Utility window, titled Criteria, is a self-validating SQL statement editor. Use it to refine the criteria limiting the number of records to be retrieved for the CDS of the mass change, beyond those specified in the top panel.

Note:

Your CDS does not have to be an exact match with the records you want to update. You can selectively exclude extraneous records from the CDS after you have created it. See Excluding Records from the Group Update.

The panel is set up so that entering values in the fields as required results in a valid SQL statement in each row. The statements are treated as nested statements, executed in the order they appear, from top to bottom. You can rearrange their sequence with the Up and Down buttons.

Note that the system does not validate these statements until you save the criteria by clicking the Save button in the upper panel. For further information see:

• CDS Criteria Examples
  
• CDS Criteria Syntax
  
• CDS Criteria Definition Rules
  
• Counting CDS Records