Main Page | Report this Page
Computers Forum Index  »  Computer - Databases - Informix  »  Informix size & sbspace location for BLOB & BLOBS...
Page 1 of 1    

Informix size & sbspace location for BLOB & BLOBS...

Author Message
Mick...
Posted: Fri Oct 23, 2009 5:25 am
Guest
Does anybody know how to get the size and sbspace location of BLOB/
CLOB data using the embedded C functions of
ifx_lo_specget_extsz() & ifx_lo_specget_sbspace() ?

for an example, who might have a table such as;

create table xxx
(
first_col integer,
sec_col "informix".blob"
);

How much disk space is taken up by the BLOB and the sbspace location
of the data is the question?


Michael
 
Mick...
Posted: Mon Oct 26, 2009 11:15 pm
Guest
On Oct 24, 1:13 am, Nilesh Ozarkar <nile... at (no spam) us.ibm.com> wrote:
Quote:
Refer to demo program - $INFORMIXDIR/demo/esqlc/get_lo_info.ec

- Nilesh -

informix-list-boun... at (no spam) iiug.org wrote on 10/23/2009 12:25:07 AM:

[image removed]

Informix size & sbspace location for BLOB & BLOBS

Mick

to:

informix-list

10/23/2009 12:30 AM

Sent by:

informix-list-boun... at (no spam) iiug.org

Does anybody know how to get the size and sbspace location of BLOB/
CLOB data using the embedded C functions of
ifx_lo_specget_extsz() & ifx_lo_specget_sbspace()  ?

for an example, who might have a table such as;

create table xxx
(
    first_col   integer,
    sec_col   "informix".blob"
);

How much disk space is taken up by the BLOB and the sbspace location
of the data is the question?

Michael
_______________________________________________
Informix-list mailing list
Informix-l... at (no spam) iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

Greate!!!

Have compiled the program and have executed it. Just wondering what
the size is in (bytes, number of pages ?).

Michael

Catalog number 6900
Size is 1421, reference count is 1
Time of last access: Mon Oct 26 15:39:06 2009
Time of last change: Mon Oct 26 15:35:38 2009
Time to the second of last modification: Mon Oct 26 15:35:38 2009

Default open flags are: 4640
Estimated size of smart LO is: 1421
Allocation extent size of smart LO is: 0
Create-time flags of smart LO are: 49
Maximum size of smart LO is: No limit
Sbspace name is sbs1
here
 
 
Page 1 of 1    
All times are GMT
The time now is Fri Dec 04, 2009 10:01 am