Help Loading table from flat fil

It could be that you are generating a lock table overflow. Check your locks setting in the onconfig file. Remember that locks will be placed on data pages as well as index pages. Mike Ballentine --------------------------( Forwarded letter 1 follows )--------------------- Date: Tuesday, 6 May 1997 3:26pm From: ernieg@hiway1.exit109.com Subject: Help Loading table from flat file. Date:Tue, 6 May 1997 13:31:31 -0500 Reply-To: ernieg@hiway1.exit109.com (Ernie Graeler) Organization: Alantic Internet Technologies, Inc. Sender: informix-list-owner@rmy.emory.edu To: informix-list@rmy.emory.edu X-Informix-List-Id: <news.37586> I am currently trying to move the contents of a table from one database to another. The way I am doing this is I've created a duplicate of the table in database1 in database2 then I unloaded the table from database1 into a flat file. Then I plan on loading the flat file into the table in database2. The problem I am having is this: The load from the flat file into the table on database2 fails with the following error: 847: Error in load file line 862.The line number changes every time I try. I looked at the file, but don't see any problems. The table has 1852 rows and is over 5MB in size. I split the file up into 4 flat files. When I loaded from the 4 flat files, everything worked and loaded OK. I see this as a problem. Informix should be able to handle a 5MB file of 1852 rows. Could it be a configuration setting? I'm running On-Line Dynamic Server Version 7.2. Any Ideas out there? Thanks in advance, Ernst Graeler egraeler@commvault.com -- Ernst F. Graeler +----------------------------------------------+ | You from Joisey!? ...Yeah I'm from Joisey!!! | | Oh Yeah! What Exit? ernieg@exit109.com | +----------------------------------------------+