PM38018: CALLING STORED PROCEDURES GENERATES MSG DSQ17811 SQLCODE -811

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If versions of a native stored procedure have been created,
  calls to the active stored procedure generate SQLCODE-811.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V9 and V10 users.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: If more than one version of a stored    *
  *                      procedure exists, a CALL to the         *
  *                      stored proc generates an SQLCODE-811.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When QMF code sent queries to DB2 to verify the existence of a
  stored procedure, it did not anticipate more than one row of
  data to be included in the result table.  If a stored proc has
  multiple versions, more than one row of data will be returned,
  thus generating an SQLCODE-811 error.
  

Problem conclusion

• When QMF queries DB2 to verify the existence of a stored
  procedure, it will now ask for only the ACTIVE version of the
  procedure.
  

Temporary fix

Comments

• ž**** PE11/10/28 FIX IN ERROR. SEE APAR PM51070  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK69195 UK69196

Modules/Macros

• DSQCBRDI DSQCDBUG DSQCMDNM DSQCRSNC DSQDCALL
  DSQDCPAR DSQDCVAL DSQFPSQX DSQFPSQ7 DSQFPSQ8 DSQFSDB2 DSQFSDB8
  DSQFSDB9 DSQFSQ44 DSQFSQ45 DSQFSSDS DSQFSSQL DSQGPSQM DSQGPSQS
  DSQGPSQX DSQGSDB2 DSQGSDB9 DSQGSQ44 DSQGSSQL DSQIPSQM DSQIPSQS
  DSQIPSQX DSQIPSQ7 DSQIPSQ8 DSQISDB2 DSQISDB8 DSQISDB9 DSQISQ44
  DSQISQ45 DSQISSDS DSQISSQL DSQ0BPKL DXECDATA DXEISDB9 HSQ9910J
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UK69195

     UP11/06/30 P F106

• R910 PSY UK69196

     UP11/06/30 P F106

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.