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

Restrictions on PowerExchange Nonrelational SQL

Restrictions on PowerExchange Nonrelational SQL

PowerExchange places certain restrictions on the SQL that it supports to access nonrelational data sources.
Reordering or aggregating the result set is not supported. The sequence of data in a result set depends on the physical sequence and whether data was accessed via an index.
The following table lists and describes SQL expressions that are not supported:
Unsupported SQL Expression or Keyword
Comment
CREATE
Creation of nonrelational tables and indexes is not supported. Define these objects by using the underlying nonrelational system.
GROUP BY
Aggregation is not supported.
HAVING
Aggregation is not supported.
JOIN
SQL on more than one table is not supported.
ORDER BY
Reordering result sets is not supported.
SELECT * FROM TABLE1
WHERE COL1 IN
SELECT COL2 FROM TABLE2
Subselects are not supported.
SELECT COUNT(*)
Aggregation is not supported.
UNION
SQL on more than one table is not supported.

0 COMMENTS

We’d like to hear from you!