PK63939: MSGDSQ10498 SQLCODEN514 WHEN (ROWLIMIT=N USED WITH RUN QUERY E.G. RUN <QUERYNAME> (R=N

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• QMF users who specify the ROWLIMIT keyword in their RUN QUERY
  syntax and attempt to scroll in the report receive:
  MESSAGE NUMBER: DSQ10498
  
  MESSAGE TEXT:
  
  DSQ10498 Non end-user SQLCODE returned from DBM.  SQLCA is as
  follows:
  SQLCODE=-514/ SQLERRM=CRSR1/ SQLERRP=DSNXERT2/
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V8.1 and V9.1 users     *
  *                 starting QMF with DSQSMRFI=YES (MR=YES)      *
  *                 using the RUN QUERY command with the         *
  *                 ROWLIMIT option.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users running the multi-row fetch       *
  *                      feature from QMF can experience         *
  *                      incorrect output when using the         *
  *                      ROWLIMIT option on the RUN QUERY        *
  *                      command. The incorrect output can be    *
  *                      either too much data or zeros or blanks *
  *                      instead of data. An SQLCODE514 can      *
  *                      occur on a command following the RUN    *
  *                      QUERY command. These problems would     *
  *                      only happen when QMF is invoked with    *
  *                      the MR=YES (multi-row fetch) option     *
  *                      turned on.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When started with MR=YES, QMF is fetching more than the ROWLIMIT
  amount if the amount of raw data is a multiple of the maximum
  number of rows that can fit in the buffer. This problem is data
  row length dependent.
  

Problem conclusion

• The QMF module responsible for multi-row fetch was using
  incorrect logic to mark the end of data indicator when certain
  conditions were met. This has been corrected.
  

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:

  UK35325 UK35326

Modules/Macros

• DSQEFSQ8 DSQFFSQ8 DSQIFSQ8
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R810 PSY UK35325

     UP08/04/17 P F804

• R910 PSY UK35326

     UP08/04/17 P F804

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.