Reference Manual

10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

PowerExchange Nonrelational SQL Syntax

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:

select col_a, col_b, ... col_n from schema.map_name.table_name [where condition]

The schema.map_name is the data map name based on the data-map naming convention. The table_name is a user-defined name that is defined in the data map.

The WHERE clause is optional. You can construct the WHERE condition 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:

basic

between

null

PowerExchange Nonrelational SQL

SQL Syntax for a Basic Comparison

LIKE Comparison

BETWEEN Comparison

NULL Comparison

General Considerations

Download Guide

Watch