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.