PI40653: UNEXPECTED DSN00518 SQLCODE518 ISSUED BY QMF V11

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer reports trying multiple queries with QMF 11:
  and receives unexpected sqlcode -518.
  DSQEC_RUN_MQ is set to 1.
  
  THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED
  STATEMENT.
  
  DB2 message ID:   DSN00518
  SQLERRD1/SQLERRD2/SQLERRD3: 00FFFEE8 00000000 00000000
  SQLERRD4/SQLERRD5/SQLERRD6: 00FFFFFF 00000000 00000000
  DB2 reason code: 0
  DB2 product ID: DSN11015
  
  DSN00518  MSGDSN00518 SQLCODE518 518
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V11.1 users.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When paging through a report which was  *
  *                      generated by running a query containing *
  *                      a SET statement followed by a SELECT    *
  *                      statement, the user unexpectedly        *
  *                      received error: 'Error processing       *
  *                      FORWARD command. Press the HELP key for *
  *                      more information.' Pressing PF1 for     *
  *                      extended help, the user sees: 'THE      *
  *                      EXECUTE STATEMENT DOES NOT IDENTIFY A   *
  *                      VALID PREPARED STATEMENT.' MSQDSQ10496  *
  *                      SQLCODE -518.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  User has set the QMF global variable to allow multi statement
  QMF queries like this:
  SET GLOBAL (DSQEC_RUN_MQ=1)
  He then ran a query like this:
  SET CURRENT SCHEMA = 'SYSIBM';
  SELECT NAME FROM SYSTABLES
  FETCH FIRST 200 ROWS ONLY;
  When the user was pressing PF8 (FORWARD) to scroll through
  the report, he unexpectedly received the error described above.
  Note that this problem is specific to running multi statement
  SQL queries (global variable DSQEC_RUN_MQ must be set to a value
  of '1') and the query must issue a SET followed by a SELECT
  that results in an incomplete data object situation. An
  incomplete data object situation means that all rows have not
  been fetched to complete the data object and the database cursor
  is still open.
  

Problem conclusion

• Module DSQDRUNQ has been modified to remove COMMIT processing
  for SQL SET statements.
  

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:

  UI28470

Modules/Macros

• DSQDRUNQ
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RB10 PSY UI28470

     UP15/06/13 P F506

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.