PM52085: SQL QUERY RUN FROM QMF GENERATES INCORRECT OUTPUT IF AN OUTER JOIN IS SPECIFIED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Incorrect output can be generated when an SQL query that
  includes an OUTER JOIN is run from QMF.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V9 and V10 users.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect output can be generated when  *
  *                      users run an SQL query that includes an *
  *                      OUTER JOIN and selects a ROWID column   *
  *                      from one of the joined tables.          *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The scenario described in the DESCRIPTION above returns a
  NULLS ALLOWED ROWID data type in the result set from DB2.
  Since this data type was not included in any DB2 specifications
  or documentation, QMF code did not support it.  This caused
  report formatting problems for the columns to the right of a
  ROWID column in a report.  Data could be missing or invalid.
  

Problem conclusion

• Support for the NULLS ALLOWED ROWID data type has been added to
  QMF.
  

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:

  UK75966 UK75967

Modules/Macros

• DSQFFSQX DSQFFSQ7 DSQFFSQ8 DSQGFSQM DSQGFSQS
  DSQGFSQV DSQGFSQX DSQGFSUM DSQGFSUS DSQGFSUV DSQGFSUX DSQGHSQL
  DSQGNSQL DSQGPSQM DSQGPSQS DSQGPSQX DSQIFSQM DSQIFSQS DSQIFSQV
  DSQIFSQX DSQIFSQ7 DSQIFSQ8 DSQIFSUM DSQIFSUS DSQIFSUV DSQIFSUX
  DSQIHSQL DSQIMRF  DSQINSQL DSQIPSQM DSQIPSQS DSQIPSQX
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UK75966

     UP12/02/08 P F202

• R910 PSY UK75967

     UP12/02/08 P F202

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.