PH47978: UNEXPECTED DSQ14118 GOING TO BOTTOM OF REPORT WITH LOB DATA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An unexpected error DSQ14118 'LOB column length exceeds
  the maximum set by DSQEC_LOB_COLMAX.' can appear when
  using the MAX PF8 or BOTTOM command to go to the end
  of a report containing LOB data. QMF global variable
  DSQEC_LOB_RETRV is set to 1. Using PF8 FORWARD and
  paging through the report works successfully. This is
  the QMF 13.1 fix for QMF 12.1 APAR PH45061.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: QMF for TSO/CICS V13.1 users of LOB data     *
  ****************************************************************
  * PROBLEM DESCRIPTION: User was running a SQL query against    *
  *                      a table containing LOB data.            *
  *                      User had the defaults set with global   *
  *                      variable DSQEC_LOB_RETRV                *
  *                      set to 1. DSQEC_LOB_RETRV set to a      *
  *                      value of 1 means that LOB               *
  *                      locators are used and the actual LOB    *
  *                      data is not fetched.                    *
  *                      The user was using the default          *
  *                      QMF form which sets the edit            *
  *                      code of the LOB columns to 'M' for      *
  *                      meta data. When running                 *
  *                      the query and typing in the MAX PF8     *
  *                      (or BOTTOM) command, the user           *
  *                      unexpectedly received DSQ14118          *
  *                      'LOB column length exceeds              *
  *                      the maximum set by DSQEC_LOB_COLMAX.'   *
  *                      When the user ran the                   *
  *                      query and pressed PF8 (Forward)         *
  *                      multiple times, the user                *
  *                      was able to successfully go to the      *
  *                      bottom of the report.                   *
  *                      *                                       *
  *                      When using the 'M' edit code on LOB     *
  *                      data columns, QMF should not be         *
  *                      fetching the LOB data.                  *
  *                      Additionally, DSQEC_LOB_COLMAX          *
  *                      settings should not be referenced.      *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Unexpected DSQ14118 while scrolling through report with LOB data
  

Problem conclusion

• QMF module DSQFQDRM was incorrectly trying to display LOB
  data when running the BOTTOM and PF8 (FORWARD MAX) commands.
  This was happening with DSQEC_LOB_RETRV set to 1 and the
  LOB edit code set to 'M'. The module has been fixed.
  *
  This is the QMF 13.1 version of the QMF 12.1 APAR PH45061.
  

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:

  UI81819

Modules/Macros

• DSQFQDRM
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RD10 PSY UI81819

     UP22/08/05 P F208

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.