Re: SQL syntax

"Mark D. Stock" wrote: > > 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??? > > What about the "Informix Guide to SQL - Syntax"? :-) > > Instead of having an "IN dbspace" clause, you have a "PUT column IN > (sbspace)" clause. There are other options too, but that's the gist of it. I tried all them - they all didn't work. Probably 'cos I was seeing a '(' and typing a ' ' - Doh!!!!! > > Cheers, > -- > Mark. > > +----------------------------------------------------------+-----------+ > | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| > | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| > | +-----------------------------------+//// / ///| > | |We value your comments, which have |/// / ////| > | |been recorded and automatically |// / /////| > | |emailed back to us for our records.|/ ////////| > +----------------------+-----------------------------------+-----------+ -- 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 #