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

Configurable CommonTableExpression support for DB2

    XMLWordPrintable

Details

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

    Description

      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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: