Unknown isam error -7120

Hi: I have an application that move some images from magnetic storage to a optical library. I do that using a insert..select way.+ Eventually I get the next error: sqlcode: 271 Could not insert new row into the table. isam: -7120 when I check this error code with the rofferr utility, it say ther is no isam error with this code. Any suggestions? Thank you

Luis Ripoll wrote: > I have an application that move some images from magnetic > storage to a optical library. I do that using a insert..select > way. > > Eventually I get the next error: > > sqlcode: 271 Could not insert new row into the table. > isam: -7120 > > when I check this error code with the rofferr utility, it say > ther is no isam error with this code. It sounds like it must be an OnLine/Optical error - I don't recall seeing error numbers in the -7000 range. It is very unusual for the ISAM error to be so large; it is normally in the range 0..-199. Atfirst I was going to suggest a memory corruption problem, but I think that an optical error is more likely now. You could probably use the rgetlmsg() ESQL/C function to get the text of error -7120; that might help. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>