PI91334: ABEND0C7 RC00000000 DSNXRINT OFFSETD7DE WHEN IMPLICIT CAST IS INVOKED TO CAST A STRING OF DIGITS TO A INTEGER OR SMALL INTEGER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C7 RC00000000 DSNXRINT OFFSETD7DE can occur when implicit
  CAST is invoked to cast a string of digits to an integer or
  small integer and this string of digits doesn't represent a
  valid integer.
  
  For example:
  
  CREATE TABLE TB1 (C1 INTEGER) ;
  INSERT INTO TB1 VALUES ( '.000000' ) ;
  
  Instead of abend, Db2 should issue SQLCODE -420 for such case.
  

Local fix

• Change from implicit CAST to explicit CAST.
  
  For example:
  
  CREATE TABLE TB1 (C1 INTEGER) ;
  INSERT INTO TB1 VALUES (INTEGER( '.000000') ) ;
  
  Or
  
  INSERT INTO TB1 VALUES ( CAST('.000000' AS INTEGER) ) ;
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 11 and Db2 12 for z/OS users of                      *
  * implicit cast.                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * An unexpected ABEND0C7 can occur at                          *
  * DSNXRINT OFFSET0D7DE (for Db2 11) or                         *
  * OFFSET0C578 (for Db2 12) when implicit                       *
  * cast is used to CAST a STRING to                             *
  * INTEGER, the string starts with a                            *
  * decimal point character followed by                          *
  * only one or more characters '0'.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  An unexpected ABEND0C7 can occur at DSNXRINT OFFSET0D7DE (for
  Db2 11) or OFFSET0C578 (for Db2 12) when implicit cast is used
  to CAST a STRING to INTEGER.  The string starts with a decimal
  point character followed by only one or more characters '0'.
  
  The following example helps to illustrate a failing
  query which can lead to the unexpected abend.
  
  1. Create a Table T1.
  
  CREATE TABLE T1 (C1 INTEGER);
  
  2. Insert a single row that contains the following string.
  
  INSERT INTO T1 VALUES( '.000000');
  
  
  When executing the INSERT above, an implicit cast is used to
  cast the STRING '.000000' to an INTEGER.  The failure can occur
  when executing the implicit cast.
  

Problem conclusion

• The code in Db2 has been modified to correct the implicit cast
  STRING to INTEGER problem.
  
  Additional Keywords: SQLINTEGER SQLCAST
  

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:

  UI55248 UI55249

Modules/Macros

• DSNXROHR DSNXROH2 DSNXROHS DSNXRIHB DSNXRIHD DSNXRIVR DSNXROHB
  DSNXROVR DSNXRIHL DSNXRINT DSNXRORR DSNXRIHR DSNXROHL DSNXRIHS
  DSNXROH1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI55248

     UP18/05/01 P F804

• RB10 PSY UI55249

     UP18/05/01 P F804

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.