PI17026: INVALID DECIMAL DATA RETRIEVED WITH ODBC LIMITEDBLOCKFETCH

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• when using ODBC LIMITEDBLOCKFETCH option column data may be not
  processed correctly when fetching from an
  SQL_DECIMAL column into an SQL_C_BINARY C data type
  
  ADDITIONAL KEYWORDS/SYMPTOMS:
  ===========================
  ODBC driver
  INCORROUT
  

Local fix

• n.a.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 10 for z/OS ODBC/CLI        *
  *                 and DB2 11 for z/OS ODBC/CLI running         *
  *                 with LIMITEDBLOCKFETCH=1.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When LIMITEDBLOCKFETCH=1, incorrect     *
  *                      data is returned when fetching from     *
  *                      a numeric column into a buffer of       *
  *                      C type SQL_C_BINARY.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When fetching from a DECIMAL, NUMERIC, SMALLINT, INTEGER,
  REAL, DOUBLE, or FLOAT column into a buffer of C type
  SQL_C_BINARY, incorrect data is returned with
  LIMITEDBLOCKFETCH=1.
  

Problem conclusion

• Code has been changed to correctly fetch SQL_C_BINARY data
  from numeric columns.
  

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:

  UI20088 UI20089

Modules/Macros

•    DSNAOCLI DSNAOC27 DSNAOG27 DSNAOSDK
  

Fix information

• Fixed component name

  DB2 ODBC/JDBC/S

• Fixed component ID

  5740XYR02

Applicable component levels

• RA17 PSY UI20088

     UP14/08/15 P F408

• RB17 PSY UI20089

     UP14/08/14 P F408

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.