RE: Loading Flat ASCII file

The best manual to read first for importing data is the Informix Guide to SQL: Reference. Read the section on the use of the dbload utility. With a simple command file that denotes the fields and the delimiter you can quick load data. If you have a large amount of data, and you have set up transaction logging, run a level 1 archive first to clear the logs. Otherwise they will fill up on you. If you are new, I suggest that you work on an unlogged database until you get comfortable. ------------ David M. Davisson Pacific Financial Printing 650-328-1500 davisson@pfp.net > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Actuary > Sent: Monday, May 03, 1999 4:12 PM > To: informix-list@iiug.org > 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! > > >