Re: Problem with dbexport (Help !!)

> > I have a weird problem with a dbexport file and I need help. A couple of > days ago I received a 4 mm tape containing a dbexport of a clientxs database. > When I tried to import it everything went fine for a while, **BUT** in the > middle of the recovery of a big (500.000+ records) table I received an ugly > message "Invalid character in date-time field" (or something like that) and > the import ended right there. After playing a little while with dbexport and > failing miserably all the times I decided to cheat. I copied the tape content > to disk using cat /dev/dat > client.exp and jumped into the file with one > of our in-house gigabyte-file editors. Surprise, surprise. The file had > "holes." (i.e. missing portions). However, for some reason dbimport was able > to read those portions (until it failed, of course) and cat was not. If > someone out there knows how to copy a dbexport from tape to disk please let > me know how to do it. > Since dbexport consists of simple loads of ascii rows, i'd suggest using oad to load the rows, with the optionion to not die on bad rows. dbload is much faster, safer, and flexible, and more forgiving on errors. -------------------------------------------------------------------- DBLOAD Load Utility INFORMIX-SQL Version 4.10.UD4 Copyright (C) Informix Software, Inc., 1984-1990 Software Serial Number AAA#C163231 Usage: dbload [-d dbname] [-c cfilname] [-l logfile] [-e errnum] [-n nnum] [-i inum] [-s] [-p] [-r] -d database name -c command file name -l bad row(s) log file <------------------------ -e bad row(s) # before abort <------------------------ -s syntax error check only -n # of row(s) before commit -p prompt to commit or not on abort -i # or row(s) to ignore before starting -r loading without locking table -------------------------------------------------------------------- -- Naomi Walker (aka N7FSA) | naomi@anasazi.com | Phoenix, Arizona Everything should be made as simple | as possible, but not simpler --Einstein | Visualize Whirled Peas