DB2 FOR LUW / DB2FORLUW / 970 - DB2

If there is a binary zero in the string, UTL_FILE writes 
contents of this string only up to the first binary zero. 
 
Example: 
 
DECLARE outfile UTL_FILE.FILE_TYPE; 
DECLARE col1data varchar(20) for bit data; 
 
CREATE TABLE forbit (col1 varchar(20) for bit data)@ 
-- 'ABC E' where the 4th byte is null char 
INSERT INTO forbit values (x'4142430045')@ 
-- after the file has been opened/setup: 
 
OPEN testcurs; 
   FETCH from testcurs into col1data; 
CLOSE testcurs; 
--stores the column in a variable 
 
SET outfile = UTL_FILE.FOPEN( dirAlias, fileName, 'w' ); 
 
CALL UTL_FILE.PUT_LINE( outfile, col1data); 
 
--Now in the file, we only see "ABC", because we stop at null. 
However, we should see "ABC^@E" ('^@' represents the null 
terminator)

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of UTL_FILE                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 FP6 or newer.                            * 
****************************************************************

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 v9.7 FP6

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC84255 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

12.12.2011
17.12.2012
17.12.2012

9.7.FP6