DB2 / SQL HexToAscii Conversion / Files larger then 1MB
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?
