The currently supported SELECT statement syntax is:
SELECT columnname [[as] columnalias] [,columnname [[as]
columnalias] ]
FROM ([[dbalias.]creatorid.]tablename [[as] tablealias])
[WHERE condition]
The following guidelines apply to WHERE
conditions:
- condition = [booleanterm [or booleanterm ]]
- booleanterm = [booleanfactor [and booleanfactor ]]
- booleanfactor = [[not] predicate |
[not]( condition )]
- predicate = [expression [not]
between expression and expression | expression [not]
in (expression {,expression }
) | expression is [not] null | expression [not]
like literalstring [escape literalstring ]
| expression relationaloperator expression
- The following relational operator symbols are acceptable:
=, <, >, <=, >=, !=, !<, !>, <>,
^=, ^<, ^>.
- expression = [( expression )
| Literal | [qualifier.] columnname
- qualifier = [dbalias.] creatorid.] tablename | tablealias