When you want to create a new condition, choose the CONDITIONS option from the Administrative Menu, or use the CONDITION command on the command line. When the Directory of Conditions panel appears, press <PF3> CREATE to create a new condition. CA Dataquery then displays the Editor panel allowing you to input your condition. An explanation of the Editor panel appears in the CA Dataquery User Guide.
Following is a sample Editor panel that appears when you press <PF3> CREATE during display of the Directory of Conditions.
Sample Editor Panel from the Dir. of Conditions
=> CREATION PANEL ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR CURRENT TABLE: ________________________________ ----------------------------------------------------------------------------- NAME: _______________ TYPE: COND__ DESCRIPTION: ___________________________________________________________ ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== .. .. .. .. .. .. .. .. .. .. ============================ B O T T O M =================================== ----------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> SAVE <PF5> NOT USED <PF6> DELETE <PF7> BACKWARD <PF8> FORWARD <PF9> UPDATE <PF10> NOT USED <PF11> RIGHT/LEFT <PF12> NOT USED
Action
Complete the top of the panel and write the condition in the text area of the panel.
Enter the 1- to 15-character alphanumeric name for this condition. Supply the table name on which this condition is based in the Current Table field. Remember to give your condition a unique name.
CA Dataquery supplies COND to specify that this is a condition and is to be saved in the condition library.
Enter explanatory information about this condition. CA Dataquery displays this description on the Directory of Conditions panel and other condition-related panels.
When the top of the panel is complete, enter the condition. Conditions can either include WITH or not. Either way is valid. Follow the rules for WITH clauses as described in the CA Dataquery Reference Guide. Press <PF4> SAVE to save the condition.
Next Step
The next step in applying the condition to a specific table is to assign the condition to a restriction definition. Select RESTRICTIONS from the Administrative Menu and see Using Conditions to Restrict Access to Rows of Data.
Examples
Some examples of conditions are:
ZIPCODE='75243'
CITY NE 'DALLAS'
|
Copyright © 2014 CA.
All rights reserved.
|
|