Re: get syntax error when loading data to a informix database

The second form should work. What are you using as a field delimiter? Informix defaults to a pipe "|". If you are using some other character you will need to include the delimiter phrase ... LOAD FROM "pathname" [DELIMITER "char"] INSERT INTO table-name commbtp@lineone.n et (Umesh) To: informix-list@iiug.org Sent by: cc: owner-informix-li Subject: get syntax error when loading data to a informix database st@iiug.org 20/12/2004 01:29 Please respond to commbtp 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. Thanks in advance Umesh sending to informix-list