> We have a db2 with the extenders that stores tiff images as blob
> fields. Insertion works fine. Now we try to extract an image (jpeg)
> from the database.
> We cannot get the whole blob with a SELECT it requires 2GB in memory!
> So, what we want to do is to grab a part of the blob as big as
> MMDBSYS.Size(Image), which is only 2MB. This can be done with
> Content--(--handle--,--offset--,--size--). We also want to receive the
> images in JPEG format with some conversion. This can be done with
> There is no function that fulfills both requests.
> Any ideas how we can achieve this?
> Thanks in advance
> Dimitris Glezos
> High Performance Computing Laboratory University of Patras, Greece
Hi, Actually, I'm trying to do the same using PHP (I have DB2 v7.2 FP5
and DB2 Image Extenders) But I'm not sure images are stored correctly in
the database and what I retrieved from the database isn't consistent...
Could you tell me how you managed to store the images as BLOB in the DB2
Posted via dBforums