PM60515: DB2 ADMINISTRATION TOOL FOR Z/OS DRIVER DOES NOT PROCESS PROPERLY SQLCODE +445 VALUE HAS BEEN TRUNCATED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 ADMINISTRATION TOOL FOR Z/OS DRIVER DOES NOT PROCESS
  PROPERLY SQLCODE +445 VALUE HAS BEEN TRUNCATED
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who run SQL in panels ADBPMESQ          *
  *                 'Edit/Run SQL Statement' or ADB21TSE         *
  *                 'Build SQL SELECT Prototype'.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect results are returned if DB2   *
  *                      returns a positive SQLCODE on a FETCH.  *
  *                      For example, a SQLCODE= +445 /          *
  *                      SQLCODE445 indicating that a data       *
  *                      truncation has occurred:                *
  *                                                              *
  *                      DSNT404I SQLCODE = 445,                 *
  *                      WARNING:  VALUE >Lob-Value<             *
  *                      HAS BEEN TRUNCATED                      *
  *                      DSNT418I SQLSTATE   = 01004             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool does not return a row if a warning
  SQLCODE=445 / SQLCODE445 is received during a FETCH.
  

Problem conclusion

• The problem has been fixed and message ADB282W:
  
  'At least one warning SQLCODE (>0) was returned during
  fetch.  'The first SQL warning was: SQLCODE >sqlcode<'
  
  is displayed with the result if an SQL warning has been
  received during FETCH.
  

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:

Modules/Macros

•    ADBMAIN  ADB28
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK77851

     UP12/04/13 P F204

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.