Re: where's the docs for this?

,Ed Stevens <spamdump_at_nospam.noway.nohow> wrote: : On 4 Dec 2002 11:25:06 -0800, afilonov_at_yahoo.com (Alex Filonov) wrote:

:>spamdump_at_nospam.noway.nohow (Ed Stevens) wrote in message news:<3deb862b.
  12044679_at_ausnews.austin.ibm.com>...
:>> I'm not having much luck finding the docs for what may be the most

    fundamental
:>> subject of all -- SQL return codes . . .
:>>
:>> For instance, everyone knows a +100 return code means 'not found' ....
:>>
:>> But which manual has the comprehensive documentation on all of those

    return
:>> codes? I've poked around in Tahiti and the ng archives, to no avail.

    I'm sure
:>> it must be there, but I've been unable to actually locate it!
:>
:>Use Error Messages manual. For 8i part number would be A76999-01. It's on
  Tahiti.

: I must be looking right at it at not seeing what I'm looking for. To be a   bit
: more specific, here's my problem.

: We are converting an application (written in Cobol from) from os/2 and db2/2   to
: NT and Oracle. After issuing a SQL statement, the pgms check the SQLCODE   field
: of the SQLCA record. This is just a numeric return code, not a full-blown   error
: message. It is these codes that I need to find and I'm not finding any : reference to this field or its values in the Error Messages manual.

: --
: Ed Stevens
: (Opinions expressed do not necessarily represent those of my employer.)

What value are you getting? Getting anything in sqlca.sqlerrm.sqlerrmc?

Helen Received on Thu Dec 05 2002 - 08:56:19 CST