alter table with blob in blobspace

I'm trying to add a blob column in a blobspace called clientspsb3, but don't find the synthax. Must be something like this : alter table t_age add ( img_nav1 blob ) put img_nav in ( clientsbsp3 ); Thanks you

Laurent LAFEUILLE wrote: > > I'm trying to add a blob column in a blobspace called clientspsb3, but don't > find the synthax. > Must be something like this : > > alter table t_age add ( img_nav1 blob ) put img_nav in ( clientsbsp3 ); ALTER TABLE t_age ADD (img_nav1 BYTE IN clientsbsp3); Look in the Guide to SQL Syntax or SQL Quick Syntax Guide both online at the Informix WEB Site for download or browsing. Art S. Kagel

Laurent LAFEUILLE wrote: > I'm trying to add a blob column in a blobspace called clientspsb3, > but don't find the syntax. Must be something like this: > > alter table t_age add (img_nav1 blob) put img_nav in (clientsbsp3); You simply specify the new type as you would in CREATE TABLE, hence: ALTER TABLE t_age ADD (img_nav1 byte in clientsbsp3); -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>

Thank you for your answer, but my question was badly explained. In fact, I must add a column in a smartblobspace ( for CLOB and BLOB ), not in blobspace ( for byte ) Regards Art S. Kagel a 'crit dans le message <37C59DCD.5080BA3E@bloomberg.net>... >Laurent LAFEUILLE wrote: >> >> I'm trying to add a blob column in a blobspace called clientspsb3, but don't >> find the synthax. >> Must be something like this : >> >> alter table t_age add ( img_nav1 blob ) put img_nav in ( clientsbsp3 );> >ALTER TABLE t_age ADD (img_nav1 BYTE IN clientsbsp3);> >Look in the Guide to SQL Syntax or SQL Quick Syntax Guide both online at >the Informix WEB Site for download or browsing. > >Art S. Kagel