Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

PowerExchange Nonrelational SQL Syntax

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
  • like
  • between
  • null