Db2 Tools

 View Only
Back to discussions
Expand all | Collapse all

Fast Unload and Common Table Expressions

  • 1.  Fast Unload and Common Table Expressions

    Broadcom Employee
    Posted Apr 04, 2018 04:00 AM

    HINT:

     

    if you need to build an Unload using a DB2 Common Table Expression (CTE), currently that facility is not available in CA Fast Unload.

     

    (CTE syntax starts with "WITH...AS...")

     

    A good potential workaround is to create a DB2 view of the CTE and unload from that.