Re: Help - Suggestions for Data Loads in Informix tables

Temporary tables isn't a bad approach if you don't have the correct tools. Personally, I would always use ESQL/C. Sometimes, it's possible to use C to split the input file into separate files for the individual tables, but this depends on the data & schema. Not suitable for tables with serial fields. Also not suitable if you need to match and update existing records. All in all, ESQL/C is the best approach !! Mike. In article <33287CBA.E5B@thomtech.com>, Ashi Chaturvedula <ashi@thomtech.com> writes >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 -- Mik Hobbs