PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.5.3
- All Products
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.
|