IT01100: CHAR(' ',0) RETURNS EMPTY STRING INSTEAD OF NULL IN VARCHAR2 ENABLED DATABASE.

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• In a VARCHAR2 enabled database, an assignment of an empty string
  value to a CHAR, VARCHAR, GRAPHIC or VARGRAPHIC should produce a
  NULL value.  However, if a string literal is not empty, consists
  of all blanks is passed as an argument to the scalar functions
  CHAR, VARCHAR, GRAPHIC or VARGRAPHIC, and has a specified length
  of 0, then an empty string is returned instead of the expected
  NULL.  The returned string might look like the following sample:
  
  values char('   ',0)
  
  1
  -
  
  
    1 record(s) selected.
  

Local fix

• Change the string literal to an empty string.  For example,
  changing the string literal to CHAR('',0) will fix this issue.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 version 10.1.0.4.                             *
  ****************************************************************
  

Problem conclusion

• The problem is first fixed in DB2 version 10.1.0.4.
  

Temporary fix

Comments

APAR Information

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

  IT01000

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

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RA10 PSN

     UP