PM30206: PROC GENERATES SQLCODE -518 ISSUING A QUERY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE -518 is generated when issuing a Query from a Proc
  after migrating to V910.
  ( sqlcoden518 )
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: QMF for TSO/CICS V9.1 and V10.1 users who    *
  *                 set the DSQEC_LAST_RUN global variable to    *
  *                 '1'.                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users who set the QMF global variable   *
  *                      DSQEC_LAST_RUN to 1 may experience SQL  *
  *                      codes -518, -514, and -501 during QMF   *
  *                      procedure or command processing.  The   *
  *                      SQL code can be seen in QMF message     *
  *                      DSQ10496 (MSGDSQ10496), which will      *
  *                      contain the SQL code error text.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  User had QMF global variable DSQEC_LAST_RUN set to 1. The
  following illustrates the problem:
  Step1: User runs a QMF query (QUERY1) that returns a report that
         does not complete (report has many rows)
  Step2: User runs a QMF procedure (PROC1) which causes the SQL
         code -518 (or SQL code -514 or SQL code -501)
  ***
  In the above scenario, QMF had fetched rows for QUERY1 and
  shown the user the first page of the report.  The report
  object was not complete.  QMF was waiting for the next
  command. The user entered the RUN PROC1 command, which
  caused QMF to load the PROC1 object and then triggered
  (incorrectly) an immediate update to the Q.OBJECT_DIRECTORY
  LAST_USED column.  The immediate update forced a close and
  commit of the open cursor used for the fetching of rows for
  QUERY1.  After the update for LAST_USED for PROC1, QMF went back
  to complete the QUERY1 report before executing the PROC1
  commands. Because there was an attempt to use the same cursor,
  the SQL code -518 occurred.
  *
  Note that this can happen when running QMF procedures from
  within procedures as well as when running individual commands
  from the command line.
  

Problem conclusion

• Prior to making updates for the Q.OBJECT_DIRECTORY.LAST_USED
  column, QMF will check to see if an incomplete report object
  exists. If it does, QMF will queue LAST_USED column updates to
  be handled at a later time.  If there is no report object in
  progress, QMF will make the immediate LAST_USED update.
  

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:

  UK64209 UK64210

Modules/Macros

• DSQDRUN
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UK64209

     UP11/01/26 P F101

• R910 PSY UK64210

     UP11/01/26 P F101

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.