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. DTLDESCRIBE Metadata
  12. PowerExchange Globalization
  13. Using the PowerExchange ODBC Drivers
  14. PowerExchange Datatypes and Conversion Matrix
  15. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  16. 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

0 COMMENTS

We’d like to hear from you!