Re: Make BLOBS go into the BLOB space
The definition of the table should now read as ...
create table wds_store
(
wds_blob_id serial not null ,
wds_blob byte IN <blobspace>,
wds_mime varchar(50),
wds_desc varchar(50),
wds_blob_size char(12)
default '0',
primary key (wds_blob_id)
);
and this should put your BLOB data in the newly created blobspace.
Thanx much,
Rajib Sarkar
Advisory Support Engineer (RAS)
IBM Data Management Solutions
Ph: 602-217-2100
As long as you derive inner help and comfort from anything, keep it --
Mahatma Gandhi
Thursday, June 19, 2003 3:53 PM
To: "Informix-List (E-mail)" <informix-list@iiug.org>
cc:
From: Adam Williams <adam@morrison-ind.com>
Subject: Make BLOBS go into the BLOB space
I have a table -
create table wds_store
(
wds_blob_id serial not null ,
wds_blob byte,
wds_mime varchar(50),
wds_desc varchar(50),
wds_blob_size char(12)
default '0',
primary key (wds_blob_id)
); - that is taking up alot of space in our primary dbspace.
So I create a blobspace as outlined in the manual.
But I can't find any information on making the blobspace be utilized.
Do I need to drop and recreate this table to force the blobs over there,
or is there some alter statement I can perform?
sending to informix-list
sending to informix-list