Re: Informix 07003 error

On Thu, 11 Feb 1999, Art S. Kagel wrote: > 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. 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