Re: where's the docs for this?

On 5 Dec 2002 14:56:19 GMT, "Ms. D.H. Harvey" <qq45_at_liverpool.ac.uk> wrote:

>,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

Wrong problem. It's not that we're getting codes we don't understand. We're converting programs from DB2/2 to Oracle, and we need to make sure that existing tests are checking for the correct codes. For example, in DB2/2 a SQLCODE of 'xyz' indicates a certain error condition, so we need to determine what value Oracle returns to indicate the same condition. We know for a fact that they aren't all the same.

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