Help Loading table from flat file.
Posted in 1997
Topics: Stored Procedures & SPL, Migration, Import/Export & Data Conversion
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 |
+----------------------------------------------+