According to the README distributed with DBD::Informix...
DBD::Informix, Version 1.00, provides limited support for user-defined
data types (UDTs), treating them as CHAR(255). To handle BLOBs and
CLOBs, use LOTOFILE() when you fetch the data and FILETOBLOB() or
FILETOCLOB() when you insert data. To handle nonblob UDTs that exceed
255 characters in length, use server-side cast to lvarchar, as in
select mycol::lvarchar from mytab;
Basically, unload the blob/clob to the filesystem with LOTOFILE and
manipulate that file in your program. The Large Object Locater Datablade
User's Guide and the Informix Guide to SQL: Tutorial (version 9.3) have
information on the LOTOFILE and FILETOBLOB/CLOB functions, both available at
I use DBD::Informix to go the other direction... Loading large text objects
into clob columns with the FILETOCLOB function. Works quite well.
Hope this helps,
>> This is what I'm getting
>> If anyone knows what's going on, it'd be great to figure this out. For
>> the moment, I think I'll just code in a work-around for the generated
>> email to simply grab the image off a web server (via the web datablade).
> That looks a hell of a lot like the LOCATOR that is used by Informix API to
> reference blobs. I don't use blobs but I do know that they are referenced by
> these locators, and the locators are not the data.
> For a relatively "pure" understanding of blobs and their locators, read the
> 4GL manual on the subject (had to do that last week by coincidence) so that
> you understand the subject. I suppose you are already familiar with the 4GL
> way of blobbing?
> With DBD::Informix, there is some detail written either into the release
> notes, or the README files or something. I'm not sure if they work or they
> fall into "some more work to be done". Go to www.google.com and do a group
> search of this newsgroup for any messages written by Jonathan Leffler wot
> mention DBD. I know he's commented about it several times, and posted some
> sample code somewhere. No doubt he'll comment when the sun rises on his side
> of the globe.