Re: Blob size from SQL
You are right to open a case, i would too in case i needed it.... i
guess this is a missing feature.
and loooooooooooonnnnnnnnnggggggggg overdue;
(some oil on the fire: dumb blobs do have a length function and they
are afaik unsupported
using HDR in dumb blob spaces!!! so...... sblobs eq blob and clob in
sbspaces are supported
using hdr and miss functions like length...)
In order to get the functions you want you need to write your own udr
See informix datablade api programmers guide (v11.50.xC5)
around pages 6.50
the status info has the size of a lo.
Sorry i have no working example
when time allows i may hack one together or maybe someone else has
one??
Superboer
On 1 mrt, 01:06, pretzel <davidegr...@gmail.com> wrote:
> On Feb 28, 1:23 pm, Art Kagel <art.ka...@gmail.com> wrote:
>
> > IB that you can use the LENGTH() function with a BLOB/CLOB type column, I
> > know you can use it with a TEXT/DATA type column.
>
> > Art
>
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > IIUG Board of Directors (a...@iiug.org)
> > Blog:http://informix-myview.blogspot.com/
>
> Thank you, Art. I always appreciate your posts.
>
> I tried the following in dbaccess:
>
> "SELECT <row_pk_ FROM <table> WHERE LENGTH(blob)=0;"
>
> and got:
>
> "674: Routine (length) can not be resolved."
>
> Same thing when trying SIZE().
>
> I see that this has been asked a couple of times in the past 10 years,
> with no definitive answer, so I suspect Informix does not provide the
> capability. Just to be sure, I have opened a tech support case to get
> the real skinny.
>
> Thank you.
>
> DG