topic Re: Issue with Info Load from Database in QlikView

Issue with Info Load from Database

Thu, 02 Feb 2012 23:16:20 GMT

Hi,

I need to extract images from a table in DB2 DataWarehouse.

The table Att contains following fields:

Id- image iD

Image type- Type of image like(image/jpeg,image/gif etc)

image- BLOB images

When I do a script like:

info select id, image

from db.att;

When i do =info(ID) in a text box all i see is Hexadecimal characters like FFA0000GH.......

I am not sure what Is wrong. When i see a preview in blob viewer also I dont see the image. The same images are being read by a JAVA app where the image is concatenated with image type ti identify it as a GIF or JPEG image. Does this have anything to do with the error? I think that Qlikview Doesn't identify the BLOb as an image without the proper image type. Is there any solution for this?

Re: Issue with Info Load from Database

Fri, 24 Aug 2012 04:26:39 GMT

i am having the sae problem.. how did u resolve it??

Re: Issue with Info Load from Database

yavoro — Fri, 31 Aug 2012 13:50:22 GMT

Hi,

have you set text box Representation option to Image?

Regards

Re: Issue with Info Load from Database

Mon, 03 Sep 2012 04:04:18 GMT

yes i have set it to image.

What actualy it is doing is that it is loading that HEX code(00AHCDF.....) as string hence unable to show as image.

However my SQL database is storing the value as IMG datatype.

Do you have any idea how to load the value as HEX not string??