Re: Make BLOBS go into the BLOB space

Adam Williams wrote: > 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 ALTER TABLE wds_store PUT wds_blob IN (space1, space2, ...); There's a few options that might be of interest to you so check the ALTER TABLE statement (PUT clause) in the Guide to SQL.

Rob Wilson wrote: > Adam Williams wrote: > >> 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? > > ALTER TABLE wds_store PUT wds_blob IN (space1, space2, ...);> > There's a few options that might be of interest to you so check the > ALTER TABLE statement (PUT clause) in the Guide to SQL. That's the smart blob (BLOB and CLOB) notation. The BYTE and TEXT version has been given by others - wds_blob IN blobspace. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/