Query band values with the same name are OR’ed. Query band values with different names are AND’ed.
(NameA=ValA1 OR … OR NameA=ValAn ) AND
(NameB=ValB1 OR … OR NameB=ValBm ) AND
…
(NameX=ValX1 OR … OR NameX=ValXx )
For more on query band usage, see Teradata Viewpoint User Guide (B035-2206).
For this example, assume that a workload is being created for batch requisition types by north or east regions, but an exception is needed to exclude accounting jobs.
Workload classification criteria cannot be manually modified from the Classification tab of the Workload Attributes window. You can, however, add more classification criteria using the Split option.
- Right-click the workload in the list on the left side of the Workload Attributes window.
- Click Split from the right-click menu.. The Split Workloads dialog box appears. For details on the fields used for splitting workloads, see Splitting Workloads.
- Click Add New Classification. The Classification tab appears, similar to the tab of the same name on the Workload Attributes window, however all functionality is enabled.
- Select the Choose another selection criteria check box. The --AND-- pane of the tab becomes visible, showing the Criteria #2 drop-down list. The list includes the items shown as check boxes in the Category pane of the Define DBQL Inputs dialog.
- Select Include QueryBand from the Criteria #2 list of the Classification tab. See Defining or Modifying Classification Criteria #2–6 for a WD for more information. The Choose box and button become enabled.
- Click Choose. The Include QueryBand dialog box appears.
- Select Load Names to display all query band names and for this example, select the Region name. Alternatively, type the value Region in the QueryBand Names box.
- Select Load Values to display all query band values, and for this example, select the North values. Alternatively, type the value North in the QueryBand Values box.
- Select Add to add the name and value pair.
-
Repeat steps 7–9 to add a name and value pair for the East region.
- When finished, click OK to return to the Classification tab.
- Click Cancel to discard your classification selections and start over.
- Click the Choose another selection criteria check box. The Criteria drop-down list appears for you to select the next criteria.
-
Select Exclude QueryBand.
Notice that Include QueryBand is no longer an option.
The Exclude QueryBand dialog box appears.
- Repeat the steps used to configure the Include QueryBand dialog box and define the accounting job whose query band you want to exclude.
-
When finished, select OK to close the dialog box and return to the Classification tab.
