Re: Loading Flat ASCII file

From: "Actuary" <actuary@visi.com> > >As a newcomer to the Informix database, I'm experiencing the general >frustrations of reading technical manuals. I'm probably in need of >"Informix for Dummies" but nonetheless: I've configured IDS, have set up a >database, and defined my first table. I'd like to import a flat ascii text >file but I am having problems getting it to import. > >The method that I am using is utilizing SQL with an "insert into" method. >IDS gives it a try, but it appears that I'm having field delimiter >problems. >The ascii file is a fixed record length, fixed field file, that is there >are >no delimiters. > >What do I need to do to simply import a common file type such as this >without having to take a two year course. Look into the DBLOAD command. The manuals are at http://www.informix.com/answers if you don't have them. If you're *really* lazy and don't want to trawl through all the manuals, try http://www.informix.com/answers/english/pdf_docs/gn7382/4372.pdf :-) HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com