Re: SQL syntax

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. 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.|/ ////////| +----------------------+-----------------------------------+-----------+