Documentation

Table of Contents:


    IBM Db2 support

    Piotr Tokarski - Dataedo Team Piotr Tokarski 2018-09-13 2018-10-05

    Available from version 7.1.

    Supported versions

    IBM Db2 LUW 9, 10, 11

    IBM Db2 on Cloud

    Connection to DB2 on mainframes require DB2 Connect license.

    Other Db2 editions may work, but due lack of testing environment, we can't provide full support.

    Supported schema elements and metadata

    Dataedo reads following metadata from IBM Db2:

    • Tables
      • Columns
        • Data type with length
        • Nullable
        • Default value
      • Primary keys
        • Columns
      • Unique indexes
        • Column
      • Foreign keys
        • Columns
      • Triggers
        • When triggered
        • Script
    • Views
      • Columns (see tables)
      • Script
    • Materialized views
      • Columns (see tables)
      • Script
    • Procedures
      • Script (for SQL procedures)
      • Parameters
    • Functions
      • Script (for SQL procedures)
      • Parameters
      • Returned value
    Found issue with this article? Comment below
    Comments (0)