Re: Help - Suggestions for Data Loads in Informix tables

This seems to become the new faq. Don't people get manual any more? For normal loading of this type there is the dbload utility. That's the one and only tool for regular loading of data from files. (The load statement in dbaccess and some other tools are only for the simplest jobs.) dbload can do a lot of things, like loading into multiple tables from one file, pulling data togheter from different parts of each line of the load file, inserting constant data and so on. If this isn't enough stored procedures to further massage the data is a good idea. Another alternative is of course a program (4GL, ESQL/C or whatever) that can do this or it can read the data and do the massaging before the data is inserted into the tables. This would probably be a good option if it's a weekly job with the same data format. For high performance loading of large amounts of data there is also the new ipload (I think that's what it's called) utility with version 7.2x. This seems to be able to do extensive massaging of the data. I haven't used it yet. Ashi Chaturvedula <ashi@thomtech.com> wrote: :Help!!! : :I would appreciate if anyone could help me with the following: I am new :to the Informix World. : :Scenario: : Have a data file with well defined record layouts. This file is :refreshed every week with new data. : :Goal: To automate the process of data loading into a normalized :Informix database with minimal manual intervention. : :Current Strategy Proposed: : Have sets of temporary tables created which mirror the file layout. :Then use stored procedures to load the data from these temp tables to :the Normalized tables. : :HELP: What's the best strategy? Any pointers to past discussions would :be helpful. : :ashi@thomtech.com Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org