Managing SQL Assurance VTI 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 Add filter.
For more information, see To filter the Violations to Ignore rules. - Click Save Workspace to save the changes to the workspace.
To add a VTI rule
To edit a VTI rule
Click Save changes to save all the changes to the Manage Violations to Ignore Rules view.
To delete VTI 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 VTI 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 that describes the rule.
Click OK .
is displayed next to each added rule.
To filter the VTI rules
To show properties for a VTI rule
- In the Product Tools perspective, select a Manage Violation to Ignore Rules view.
- In the Violations to Ignore Rules grid, select a rule.
- Perform one of the following actions:
- Click Show properties .
- Double-click the selected row
- Right-click the selected row and select Show properties from the context menu.
- To view the SQL statement, click SQL.
- Click Close.
Comments
Log in or register to comment.