Обсуждение: is the sqlca.sqlabc value unique for each response type

Are the values that are populated in sqlca.sqlabc unique to response
type?  IE, when i get a failure for 'ERROR:  Cannot insert a duplicate
key into unique index "myindexname"' will the sqlca.sqlabc value always
be the same?

I'm looking for a way to determine if my failure is of this type w/o
having to to a string compare on the error message.

thanks,
reid

> Date: Wed, 20 Nov 2002 22:40:59 -0500
> From: Reid Thompson <reid.thompson@ateb.com>
>
> Are the values that are populated in sqlca.sqlabc unique to response
> type?  IE, when i get a failure for 'ERROR:  Cannot insert a duplicate
> key into unique index "myindexname"' will the sqlca.sqlabc value always
> be the same?
>
> I'm looking for a way to determine if my failure is of this type w/o
> having to to a string compare on the error message.
>
Why don't you check sqlca.sqlcode (or in SQL92: SQLCODE)?
It should contain a specific error code.

Christoph Dalitz