Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2779

Configurable CommonTableExpression support for DB2

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 8.7
    • 8.5
    • JDBC Connector
    • None

      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

            rhn-engineering-shawkins Steven Hawkins
            rokhmanov_jira Andriy Rokhmanov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: