Thread: 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