Re: dbimport with procedures

In article <432f77$8rr@cssun.mathcs.emory.edu> geoffc@fourgen.com "Geoff Clarke" writes: > }> I do a dbexport of the database and then I get an error when I > }> do a dbimport. The error is: > }> > }> ***prepare sqlobj > }> 674 - procedure (fourgen.creditinverse) not found. > }> > }> 111 - ISAM error: no record found. > }> > }> I think the problem is that this procedure that is trying to be > }> created calls (or has included in it) the procedure called > }> creditinverse. Unfortunately, creditinverse is yet to be > }> imported (it comes later in the tape). > }> > }> Have you heard of this problem, or is it an Informix known bug? > }> Is there a workaround? Dear Geoff, About the only idea I can come up with is that you dump the dbexport to disk and move the CREATE PROC stuff around manually. Then re-run the dbimport. If it is a bug, it would make you laugh if it didn't make you cry! HTH, Spokey the Wheeler------------------------------------------------------------- "Billy Boy" - das aufregende andersche kondom!