[
https://issues.jboss.org/browse/TEIID-2779?page=com.atlassian.jira.plugin...
]
Mark Addleman commented on TEIID-2779:
--------------------------------------
Ah, that's an interesting twist. I don't have an easy way of testing that right
now. Perhaps Andriy can give that a shot. We'll let you know.
Configurable CommonTableExpression support for DB2
--------------------------------------------------
Key: TEIID-2779
URL:
https://issues.jboss.org/browse/TEIID-2779
Project: Teiid
Issue Type: Feature Request
Components: JDBC Connector
Affects Versions: 8.5
Reporter: Andriy Rokhmanov
Assignee: Steven Hawkins
The LIMIT clause (FETCH FIRST...) inside CTE (WITH...) is not supported on pre-V9
versions of DB2 on z/OS, or new versions of DB2 running in Compatibility Mode.
The CTE support in DB2 translator should be configurable.
See more information:
https://community.jboss.org/thread/235503
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira