RE: load a table includes 350 000 records

Muthana Why not? What error messages are you getting? 1. Turn logging off (using ontape) load the data then turn back on. 2. Load into a RAW table then use 4GL or C to load to your real table with BEGIN WORK, COMMIT around every (say) 1,000 records. 3. As 2 except load into an unlogged temper table. 4. As 2 except ALTER the table to normal after the initial load. 5. Use DBLOAD. 6. Load using a high level language with BEGIN COMMITS around every (say) 1000 records 7. Use one of the various IIUG utilities to load the data Any of the above (in no particular order) are usable to overcome this problem. Keith -> -----Original Message----- -> From: Muthana.AL-Temimi@tu-harburg.hamburg.de -> [mailto:Muthana.AL-Temimi@tu-harburg.hamburg.de] -> Sent: Thursday, April 28, 2005 1:45 PM -> To: informix-list@iiug.org -> Subject: load a table includes 350 000 records -> -> -> Hello there, -> -> I tried to load table including 350 000 records. But -> Informix cannot do that for me. I divide the records into -> three parts then I loaded them. -> -> My question what shall I do to avoid this process. What I -> mean I don't need to divide the records into three parts and -> load them serial -> -> Any help will be good -> -> Muthana -> ------------------------------------------ -> Technische Universit't Hamburg-Harburg -> Muthana AL-Temimi -> IuK - Referat -> Tel.: 040 42878 3294 -> Email: muthana.al-temimi@tu-harburg.hamburg.de -> -> -> sending to informix-list -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ********************************************************************************** sending to informix-list