Re: Loading Flat ASCII file

Actuary Use dbload. HTH Sujit Actuary <actuary@visi.com> on 05/03/99 04:11:30 PM Please respond to Actuary <actuary@visi.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Loading Flat ASCII file 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. Assistance is appreciated!