Re: Help needed with Informix

On Wed, 21 Jun 1995, Alex Behrakis wrote: > I am using INFORMIX-ESQL/C v5.01 > A database has been unloaded using the utility UNLOAD to migrate data to a new > database. I want to LOAD these ASCII files into a "new" database. > > Question: Does the database I want to LOAD into have to be completely empty, > that is, no pre-existing tables, attributes and data? > Can the files that the dbschema utility create be modified to migrate this > data into a database that already has pre-existing data in it? > Will the LOAD or dbload utility have a problem loading this database with > existing data or can that be remedied by modifying the dbschema output file? > Any and all help would be greatly appreciated. > Thanks in advance. > Alex, No. The table you're loading into does not have to be empty. I think the isql load will stop at the first error, due usually to a duplicate index or column format problem. Dbload is much slicker and offers many controls, and error logging if so desired. It will report the problems to the log with the data in question and gracefully move on. With Dbload, if you're going to be writing a large number of records, make sure to disable the transaction log or to make a copy, then zero it out. BTW, the manual is very helpful about all the features of dbload. P.S. Sally Woolrich wrote, re dbload: i) In SE turn of the logging first by updating the 'syslog' row in systables (so tabtype != 'L') and then run 'dbload'. I don't know if there is an OL equivalent to this. ii) In SE & OL drop the indexes (if any), load the data & recreate the indexes. iii) In SE & OL ensure that the file being loaded is on a different device to the table being loaded into, otherwise the heads can fly many miles, inches, centimetres or whatever in the process. Regards ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================ Yours, Nick ********************************* Nick Nobbe, Library of Congress NLS/BPH mail: nnob@loc.gov *********************************