PK16393: SQLCODE-518 IN QMF TABLE EDITOR AFTER SQLCODE-438.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• User gets an SQLCODE -518 when trying to add a value to a
  table after having received an SQLCODE -438 when entering data
  that violates a trigger condition.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO and CICS V72 or V81 users.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. SQLCODE -518 is received in QMF      *
  *                      Table Editor ADD mode when user tries   *
  *                      to add a value after first receiving an *
  *                      SQLCODE -438.                           *
  *                      2. SQLCODE -401 is received in QMF      *
  *                      Table Editor CHANGE mode when user      *
  *                      searches for a value that has been      *
  *                      defined as a distinct type (UDT).       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1.  The SQLCODE -518 was caused by a ROLLBACK that was
  initiated by an error in the message handler when it
  encountered an unmapped message for the -438.  Several other
  unmapped messages were discovered, and encountering them would
  have produced the same error condition.
  2.  The SQLCODE -401 was caused by invalid SQL that was
  generated by QMF when a search was requested for a value that
  was defined as a distinct type.  The strong typing enforced by
  DB2 for UDTs requires that the name of the distinct type be
  included in the query's syntax, thus increasing the number of
  bytes needed to indicate the value for which the SQL is being
  constructed.  However, the structure of input fields in the
  Table Editor allows a field length of only the actual defined
  variable's length. This field is too small to accommodate the
  name of the distinct type as well as the actual value.
  

Problem conclusion

• 1.  The message mapping module was corrected to map SQLCODE
  -438 and other unmapped codes properly.
  2.  The Table Editor CHANGE mode search function was changed to
  issue a new error message indicating that searches cannot be
  made for distinct types in the Table Editor.
  

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:

  UK11470 UK11471

Modules/Macros

•    DSQCBMLA DSQCBRDI DSQCBRDX DSQCELTT DSQCEMSG
  DSQCRSNC DSQDSDB2 DSQESDB2 DSQGDRQM DSQISDB2 DSQIWSQL DSQPNLE
  DXEICS   DXENRW   DXEORC   DXYE0120 DXYE1676 DXYE2412
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R720 PSY UK11470

     UP06/02/09 P F602

• R810 PSY UK11471

     UP06/02/09 P F602

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.