I am getting a problem while loading data. A C++ program reads text file holding more that 1 million records and loads the data into Informix database with simple insert or update statements, one per line of data from text file.
After a certain number of records are inserted or updated the insert or update statements start failing with Informix Error Code 349. This does not happen at the same record everytime. So I guess it has to do something with Informix Configuration.
If anybody has faced this problem and know the answer, please help me.
Originally posted by thedafna
can you retrive the records you loaded- until it fails?
My guess is no, because the error is you did not connect to the database.
Yes I can retrieve the partially loaded records. Actually the network connection times out giving error code 25582 and after that it gives error code 349 which is understandable because the connection is no more there. But what causes the network connection to time out suddenly while processing is still not resolved.
This is verry weird.
349 occurs when your database is not open. Are you sure that the C++ program doesn't close the database?
What are your connection settings? C++ on WinNT? with ODBC?
Or both on Unix?
I might suggest you to look into the HPL (High Performance Loader).
This product is included in your engien software. Is is typically used to load lots of data into and out from the database.