Hi,

I am trying to load data from an external file to a table,but this has been very frustrating.

I ahve inormix 9.4 on win2K.
I use this syntax and keep on getting this error,where am I wrong,do I need to have anyother thing installed.


create external table test1 (id int) using ( datafiles ( C:\Documents and Settings\informix\Desktop\emp.dat),format delimited,delimiter "," rejectfile "C:\Documents and Settings\informix\Desktop\emp.log" ,express);

201: A syntax error has occurred.
Error in line 1
Near character position 8


I am new to informix and would like to load data from a external file to the database.

Thanks
Micky

create the table
then load the data

load from "filename"
insert into "tablename"

if there are a lot of records in the file then take a look at the dbload
command. With dbload you can commit after so manu rows, so you do not get the long transaction.

Cheers

hi,
thanks for this info,I could load data using the dbload,but infortunatly am having a geopoint data type which seems to have some restriction with dbload.

Is there any other ulitity i can use.

thanks
michael

Sorry, never worked with a geopoint datatype, can you give me an example of what it looks like?