You are here: Using Condition Tables and the Record Dictionary > Using Condition Tables > Creating a Conditions File
Creating a Conditions File
Conditions consist of combinations of comparisons, parentheses, and ANDs, and ORs to verify the correct results. Conditions are stated in this format:
ConditionName : {valid conditions}
Conditions can use the following:
- Variable names from the Record Dictionary
- Quoted strings
- Numeric constants
- Comparison operators, such as <, >, =, <=, >=, <>, !=, !<, and !>
- ANDs
- ORs
- Parentheses ( )
- Reserved words, such as ZERO and SPACES
Here are some examples:
Cond1 : ACSA > 9900 OR (ACSC = 4173 AND DTAT = ZERO)
Cond2 : (DTV1 = 3936.50 OR DTAT > 1) AND (DTV1 > -2 OR DTAT = 0)
Cond3 : (BMV1 <> SPACES AND ( DTVM1 = "CREDIT" OR DTAT > 0 AND BMV1 = "PAYMENT"
Cond4 : CustomerType = "A"
Note | The variables used above are defined in the Record Dictionary example. |
© Copyright 2020, Oracle and/or its affiliates. All rights reserved. Legal notices.