SQL syntax

What is the syntax for adding a blob column to a table and specify the smartblob it's to go into? dbaccess table alter doesn't work (9.30) doesn't recognise smart blobs, adding from sql is straightforward but I can't get the location to work correctly. I know it's in the FM, but where??? -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

drop table tab_smart; create table tab_smart (col1 int); alter table tab_smart add (col2 byte in blob_dbspace1); alter table tab_smart add (col3 clob),put col3 in (sblob_dbspace1); Subtle huh ;) Informix Guide To SQL Alter Table Mash it up. Paul Watson wrote: > What is the syntax for adding a blob column to a table and > specify the smartblob it's to go into? > > dbaccess table alter doesn't work (9.30) doesn't recognise smart blobs, > adding from sql is straightforward but I can't get the location to > work correctly. > > I know it's in the FM, but where??? >