alter table with blob in blobspace
Laurent Lafeuille asked how to add a blob column in a named blobspace with ALTER TABLE. Art S. Kagel and Jonathan Leffler answered with ALTER TABLE ... ADD (col BYTE IN blobspace). Laurent replied that he actually needed a CLOB/BLOB column in a smartblobspace, not a blobspace. No answer for that was given in the thread.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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