Db2 Tools for zOS

Db2 Tools for z/OS

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Multi-Statement Queries in QMF Visual Query

    Posted 06/14/21 04:56 PM
    I’m using QMF for Workstation 12.2 and getting errors running multi-statement queries that ran successfully in version 11.1 as regular queries which produced multiple result sets.
    Is this because 12.2 no longer has just plain queries, only Visual or Analytic?

    Sent from my iPhone
    #Db2Toolsforz/OS


  • 2.  RE: Multi-Statement Queries in QMF Visual Query

    Posted 06/15/21 08:18 AM
    MIchael, Multi statement queries are supported in QMF 12.2. It may be that the Global Variable governing their use may be set to zero.
    Please check the following:
    1) Use the menu View>Preferences>Global Variables
    2) Scroll down to the variable DSQEC_RUN_MC and check its value. It should be 1 to allow mutli  statement queries or 0 to NOT allow them.

    If this is not the issue please open a support ticket and specify the exact verision of QMF 12.2 from the menu Help>About QMF for Workstation.

    ------------------------------
    shawn sullivan
    ------------------------------