Re: Just scratching my head...

Art Kagel's myexport/myimport has many advantages. In particular, it doesn't lock the source database, so it can be used on a production instance. Why not use that instead if you are having trouble with dbexport/dbimport? You can download the C source code from www.iiug.org. Regards, Doug Lawry <davidegrove@gmail.com> wrote in message news:2e1bcf03-c424-452a-ab81-f50c71a1db93@o4g2000pra.googlegroups.com... > We are currently working with a contractor and a consortium of several > states on a large project. Each state is free to choose its own > database. (We are using Informix.) > > The contractor has past experience with Oracle. > > One of the contractor's on-site staff was quite surprised today, after > encountering defects (-201 error) with dbimport. We were attempting > to import into R10 a database exported from R11.5. (The problem was > the dbimport being unable to use the *.sql file produced by > dbexport). I explained to him how we deal with the problem (usually > just pulling out the table DDL to use with dbimport, while using > dbaccess to run the remainder. I told him that the situation is > pretty common in our experience, and that IBM has know about it at > least since about 5 years ago when we had (an unresolved) tech support > case on it. The contractor staff person was mystified that such a > basic utility could be defective. I admit that I, too, am quite > annoyed with it, every time I encounter the problem. > > I heard him later on the phone talking to his firm. I don't think > Informix won any gold stars today. > > DG