PK54838: QMF TSO/CICS V8 V9 DOES NOT DISPLAY INCORRECT COLUMN NAME AFTER RECEIVING SQLCODE-206 WHEN CONNECTED TO DB2 FOR LUW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When QMF is connected to a DB2 for LUW database, QMF reports
  a SQLCODE -206 situation with a message that does not contain
  the name of the column that was not found.  Message appears
  as, "Column   is not in any table named in the query."
  Additional search args:
  SQLSTATE 42703 SQLCODEN206 SQLCODE-206
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO and CICS V810 and V910 users *
  *                 who connect to non-DB2 for z/OS databases.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users who connect to NON-DB2 for z/OS   *
  *                      databases (like DB2 LUW or DB2 AIX)     *
  *                      that are Version 8.1.5 or higher can    *
  *                      experience incorrect or incomplete SQL  *
  *                      error related messages. For example, a  *
  *                      user had connected to a DB2 LUW V8.2.6  *
  *                      (SQL08026) server. He ran the query:    *
  *                      SELECT NOTTHERE FROM SYSIBM.SYSDUMMY1.  *
  *                      He expected to see a QMF error message  *
  *                      that said: 'Column NOTTHERE is not in   *
  *                      any table named in the query.' Instead, *
  *                      he saw error message: 'Column   is not  *
  *                      in any table named in the query.'       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  QMF was incorrectly calling the DB2 for z/OS V8.1.5 and higher
  SQL error handling module in all cases where any database of any
  type was V8.1.5 and higher.
  

Problem conclusion

• QMF module DSQIMSGM has been corrected to call the DB2 for z/OS
  SQL error handling routine, DSQISDGN, only when in a DB2 for
  z/OS V8.1.5 or higher server. QMF error handling for non DB2 for
  z/OS servers will be handled as it previously was. Note that
  this problem is not restricted to any particular SQL code, but
  either incorrect or an incomplete SQL error message could be
  seen for any SQL code-related error message that occurs
  when QMF is running in a non-DB2 for z/OS server (V8.1.5 or
  higher).
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK30414 UK30417

Modules/Macros

• DSQIMSGM
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R810 PSY UK30417

     UP07/10/20 P F710

• R910 PSY UK30414

     UP07/10/20 P F710

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.