After you define two or more local or global exception directives, you can set the precedence. Teradata WA uses the precedence to determine the exception directives that are more important to honor in the event of a conflict.
Teradata WA typically honors local exception directives before global exception directives.
Note that Teradata WA does not consider precedence when evaluating exception directives. Teradata WA only considers precedence when performing the actions you specified.
- On the Exception tab for a WD, or in the Global Exceptions view, select Precedence. The Exception Precedence dialog box lists all exceptions defined for a workload, and indicates their priority in descending order. By default, the exceptions are listed in the order in which they are created.
- To change the priority of an exception, select the exception, and select the up or down arrow to move it to its desired location.
- Repeat step 2 for each exception whose priority you want to change.
- Click OK to accept the priority listing and close the dialog box.