|
Problem IC84255
|
Status: Geschlossen |
IF THERE IS A BINARY ZERO UTL_FILE WRITES CONTENTS OF THIS STRING ONLY UP TO THE FIRST BINARY ZERO |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
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) |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users of UTL_FILE *
****************************************************************
* PROBLEM DESCRIPTION: *
* 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) *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 10.1 FP1 or later *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
Problem First Fixed in DB2 10.1 Fix Pack 1 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 13.06.2012
10.12.2012
10.12.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
