PowerExchange nonrelational data sources support SELECT, INSERT, UPDATE, DELETE, and TRUNCATE statements.
The basic syntax of a SELECT statement that is supported by nonrelational data sources is as follows:
is the data map name based on the data-map naming convention. The
is a user-defined name that is defined in the data map.
The WHERE clause is optional. You can construct the WHERE
from one or more clauses that specify simple comparisons or other types of conditions. Join these clauses by using one or more of the Boolean operators AND, OR, and NOT. If you do not use parentheses to indicate the order of evaluation, the default order of NOT > AND > OR is used.
A simple comparison is one of the following types: