Managing Violations to Ignore rules
To add a Manage Violations to Ignore rules view
- In the Product Tools perspective, select or add a SQL Assurance view.
- In the SQL Assurance detail view, click Manage Violations to Ignore Rules.
The Manage Violations to Ignore Rules view is displayed. - (Optional) To filter the VTI rules displayed, click View settings.
For more information, see Filtering the Violations to Ignore rules. - Click Save Workspace to save the changes to the workspace.
To add a Violations to Ignore rule
To edit a Violations to Ignore rule
Click Save changes
to save all the changes to the Manage Ignore Rules view.
To delete Violations to Ignore rules
- In the Product Tools perspective, select a Manage Violations to Ignore Rules view.
- In the Violations to Ignore Rules grid, select one or more rules for deletion.
- Click Delete rule
is displayed next to each rule that you selected to delete. . - Verify the rules that you selected to delete. You can undo the deletions by selecting one or more rules marked for deletion and clicking Reset rules .
- Click Save changes to save the changes to the Manage Violations to Ignore Rules view.
To copy a Violations to Ignore rule
- In the Product Tools perspective, select a Manage Violations to Ignore Rules view.
- In the Violations to Ignore Rules grid, select a rule to copy.
- Click Copy rule .
In the Copy Violations to Ignore Rule dialog box, edit the contents of the following fields as needed:
Field
Description
Rule name
Enter a pattern for the Rule message number.
Type Select the type of SQL statement to which the rule applies from the following values:
- All types
- Static SQL
- Dynamic SQL
Collection
Enter a pattern for the Db2 Collection ID for which you want to create a rule. You can use the % wildcard. A blank field is interpreted as containing a single % wildcard.
Package
Enter a pattern for the Db2 package name for which you want to create a rule. You can use the % wildcard. A blank field is interpreted as containing a single % wildcard.
Version Enter a pattern for the Db2 package version for which you want to create a rule. You can use the % wildcard. A blank field is interpreted as containing a single % wildcard. SQL The SQL options are shown only for rules defined to use the SQL statement as criteria. Select the appropriate option button from the following options:
- Use the SQL statement as criteria
- Allow any statement
To view the full statement, click View SQL
.Comment
Enter a comment describing the rule.
Click OK.
is displayed next to each added rule.
Filtering the Violations to Ignore rules
To show properties for a Violations to Ignore rule
- In the Product Tools perspective, select a Manage Violation to Ignore Rules view.
- In the Violations to Ignore Rules grid, select a rule.
- Click Show properties .
- To view the SQL statement, click SQL.
- Click Close .
Comments