Adelia conditions are specified using the *COND( ... ) parameter.
This condition is used to select records. The syntax for the condition is very similar to the Adelia condition for the IF instruction.
The syntax of a condition for VADELIA, SADELIA or WADELIA programs is as follows:
<SQL Condition> |
: |
'(' <SQL Condition> ') |
|
| |
'NOT' <SQL Condition> |
|
| |
<SQL Condition> 'AND' <SQL Condition> |
|
| |
<SQL Condition> 'OR' <SQL Condition> |
|
| |
<SQL Exp> <Simple Comp Oper> <SQL Exp> |
|
| |
<SQL Exp> 'START_WITH' <SQL Exp> |
|
| |
<SQL Exp> 'CONTAINS' <SQL Exp> |
|
| |
<SQL Exp> 'BETWEEN' <SQL Exp> ';' <SQL Exp> |
|
| |
<SQL Exp> <Complex Comp Oper> <SQL Exp> <SQL Exp Enum> |
|
|
|
<SQL Exp> |
: |
'(' <SQL Exp> ')' |
|
| |
<SQL Exp> <Arith Oper> <SQL Exp> |
|
| |
'-' <SQL Exp> |
|
| |
<Num Cst> |
|
| |
<Alpha Cst> |
|
| |
<Host Variable> |
|
| |
<column> |
|
| |
<SQL Scalar Fct> '(' <Exp> <List SQL Exp> ')' |
|
|
|
<SQL Exp Enum> |
: |
' ;' <SQL Exp> <SQL Exp Enum> |
|
| |
EMPTY |
|
|
|
<SQL Exp Lst> |
: |
' ,' <SQL Exp> <SQL Exp Lst> |
|
| |
EMPTY |
|
|
|
<Host Variable> |
: |
':' <Variable> |
|
| |
':' <Array element> |
|
|
|
<Column> |
: |
<correlation> '.' <Column Name> |
|
| |
<Column Name> |
|
|
|
<Complex Comp Oper> |
: |
'<>' |
|
| |
'=' |
|
|
|
<Simple Comp Oper> |
: |
'<=' |
|
| |
'>=' |
|
| |
'<' |
|
| |
'>' |
|
|
|
<Arith Oper> |
: |
'+' |
|
| |
'-' |
|
| |
'*' |
|
| |
'/' |
|
|
|
Examples of Adelia condition >>