DB2 / SQL HexToAscii Conversion / Files larger then 1MB

enderl — Tue, 14 Oct 2014 12:18:39 GMT

Hi All,

following issue. We are using a DB2 database, storing pictures in hex format. Using these pictures in our enviroment, a conversion into ascii is necessary. The following script/sql statement works fine, but only for files sized <1MB, files larger then 1MB are stored with size 0KB.

Table1:

LOAD "FALL_REFERENZNUMMER",

HexToAscii("FILE_CONTENT", '[.....] AS FILE_CONTENT;

SQL SELECT *

FROM [USER.DATABASE]

WHERE FALL_REFERENZNUMMER = $(vReferenznummer);

DROP TABLE Table1;

Anyone have the same issue for hex files >1MB on loading and converting HexToAscii?

THX for any hints!

topic DB2 / SQL HexToAscii Conversion / Files larger then 1MB in QlikView

DB2 / SQL HexToAscii Conversion / Files larger then 1MB