Does SQLERRM help?
"Ms. D.H. Harvey" <qq45_at_liverpool.ac.uk> wrote in message
news:asnpej$b5o$1_at_news.liv.ac.uk...
> ,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 Fri Dec 06 2002 - 02:49:04 CST
