DQ Internal Security › Limiting Access to Rows Using Conditions and Restrictions › Maintaining Conditions › Deleting Conditions

Deleting Conditions

To delete a condition from CA Dataquery, select the CONDITIONS option from the Administrative Menu, or use the CONDITION command from the command line. When CA Dataquery displays the Directory of Conditions panel, scroll through the listing of condition names until you display the condition you want to delete. Position the cursor beside that condition and press <PF6> DELETE. CA Dataquery immediately deletes that condition and refreshes the panel. All restrictions containing the deleted condition should be updated, although, the deleted condition is ignored when the restriction is applied at query execution.

Once you have deleted a condition from the Directory of Conditions panel, that condition no longer exists. If you have made an error, you must re-create that condition or restore it from a backup.

You can also delete a condition while viewing it on the Editor panel. Because the condition displayed on the Editor panel is in the Active Query Area, the deleted condition can be immediately restored by entering EDIT * in the command field. When CA Dataquery redisplays the condition, you must save that condition as if it were a new condition by pressing <PF4> SAVE.