Re: need help on load flat file to IUS

Jacque, Probably your IUS table enforces referential constraints, I believe our dumped file consists of a column in a row which is not in the referenced table. For example lets assume emp.state is a foreign key to state.state_id, then you can't insert a row into emp table with a state column that does not match state_id in state table. Look at your file at line 1, character 91 and check to see which column it corresponds to, that column must be a foriegn column referencing some other table. Remember if the error were at line 'X' then all the records prior row 'X' will be inserted, so if you run the script again you might end up loading duplicate records.... HTH Future Informix DBA -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading