Re: Informix 07003 error

> > Yang Yang wrote: > > > I am new to Informix, could someone tell me what does the above error > > > means and preferably point me to a reference of all error codes? > > > > There is no such Informix error. All Informix message numbers are > > negative. Please post the entire message you saw and in what context > > it occurred (ie. from an ODBC application written in VBASIC on WinNT or > > whatever). > > Agreed; SQLCODE and sqlca.sqlcode error numbers are always negative. Are they ALWAYS negative? What about +100/-100? 100 No matching records found. -100 ISAM error: duplicate value for a record with uniquekey. I'm pretty sure bothe show up in sqlca.sqlcode. (I hope I'm right, as it's not often one gets to correct either Art or John, let alone both at the same time.) > However, there's also SQLSTATE, which can be found via GET DIAGNOSTICS. And > that leads us to the answer -- the GET DIAGNOSTICS section of the 9.1 manuals > documents 07003 as 'Cursor specification cannot be executed'. I'm not clear > what that really means. It might that the you're trying to EXECUTE a cursor, > perhaps? > > Interesting note: there is no standardized way of getting the SQLSTATE codes > translated into text. > > Yours, > Jonathan Leffler (jleffler@informix.com) #include <wish/I/was/skiing.h> > Guardian of DBD::Informix v0.60 (v0.61_02) -- http://www.perl.com/CPAN > Informix IDN for D4GL & Linux -- http://www.informix.com/idn > Mark Collins mcollins@us.dhl.com