Re: get syntax error when loading data to a informix database
Umesh wrote:
> Hi
> I have ids 9.4 oon windows and csdk. l successfully connected
> to the database using Visula Basic 6.
> When l build a string for example
> SQL1 = "select * from hse2 where field1 matches " & "'a*'
> and execute using : DbaseConn.Execute (SQL1) it works fine.
>
> When l try to load data to a table :
> SQL1 = "load from " & " 'd:\\x.unl' " & " insert into hse2"
> or
> SQL1 = "load from 'd:\\x.unl' insert into hse2
>
> I get a syntax error -201. Anyone know why.
Yes, LOAD & UNLOAD are not SQL commands. They are built-in commands for
tools like dbaccess, but not part of the SQL language.
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+
sending to informix-list