Re: load from flat file

Depedns on the format of the flat file. If it's pipe-delimited, LOAD should work as described below. Otherwise, you probably have to use the high performance loader or write a program to convert the file. Gursoy YERLI wrote in message <71sh63$5mo$1@news.xmission.com>... > >Hi Folks, > >I am trying to create stored procedure to load data from flat file into >a table. > >load from "data.txt" >insert into table_name> >does not work. Is there any other way to accomplish this. Thank you. > >By the way we are using Informix DS 7.23 for NT 4.0 server. > >Gursoy YERLI