Re: .TXT files

Hello, Brian! You wrout: > Message-ID: <2sle83$fgj@emory.mathcs.emory.edu> > > Is there a way of loading data from a .TXT file > into informix database (ONLINE 5.0) ? Yes. You can do that with Informix's dbload utility. It has ability to load data from plain ASCII files. You can also specify columns for any field of the input line. This line(s) can be produced as the result of command execution (from DOS application): USE _data_base_file_name_ COPY TO _ASCII_file_name_ SDF Every field will occupy as many columns as in database file. So, you don't need to use sed or awk. Regards, Serge --- | Serguey N. DMITRENKO, programmer Phone: (0622) 35-77-45, 92-45-20 | | JV "INTER-WEST" Ltd. E-mail: snd@inwest.donetsk.ua | | 4 Shevchenko blvd, Donetsk-50, 340050 UKRAINE | +____________________________________________________________________+