Re: load from flat file

In article <3641ea4a.0@news.one.net>, "Thomas J. Girsch" <tgirsch@iname.com> wrote: > Depedns on the format of the flat file. If it's pipe-delimited, LOAD should > work as described below. No. You can not use load statement in stored procedure. > 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 > > -- Vardan Aroustamian -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own