Re: Restarting a dbimport

Joe Trubisz wrote: > > Hi... > > I had a dbimport fail after 12h because the dbimport exported > 2-tables with the same name, but different owners. Dbexport > apparently didn't like that. Unfortunately, it happened almost > at the end of the script. Without rerunning the whole thing > all over again, is there a way to just 'pick up' where it left > off, after the offending part of the script is removed? > > Thanks in advance. > > Joe I am afraid it's too late now, but anyway: As Steven pointed out, editing *.sql won't enable you to restart dbimport, but you can run the rest of the script from dbaccess. However, you will have to do some tweaking: 1) add 'load from xxxx insert into yyyy' statements after 'create table's 2) if your export is on tape, you will have to use dd, mt and such creatively to get individual *.unl files to your disk. Good luck! Dragi "Bonzi" Raos +--------------------------------------------------------+ | 4-MATE Information Engineering Inc. | +--------------------------+-----------------------------+ | 4-MATE | Tel: +385 (1) 242-116 | | Kosa bb | +385 (1) 242-126 | | 10000 Zagreb | Fax: +385 (1) 242-121 | | Hrvatska (Croatia) | e-mail: bonzi@4mate.hr | | | URL: http://www.4mate.hr | +--------------------------+-----------------------------+