Detect insert failure due to duplicate unique index

Thread view:

dharmadam - 24 Aug 2004 17:34 GMT

Is there a way to specifically identify the insert failure to a DB2
table due to duplicate index. I am geting "General Error". I am using
JDBC-ODBC bridge. I have tried getting SQLCode and SQLSate, but gives
0.

Reply to this Message

Robert Klemme - 24 Aug 2004 18:45 GMT

> Is there a way to specifically identify the insert failure to a DB2
> table due to duplicate index. I am geting "General Error". I am using
> JDBC-ODBC bridge. I have tried getting SQLCode and SQLSate, but gives
> 0.

The bridge has not a very well reputation. Can't you use a DB2 driver?

robert

Reply to this Message

dharmadam - 26 Aug 2004 14:33 GMT

Thanks for the tip. I used DB2driver, and able to get -803 error
during insert, indicating the duplicate primary index.

> > Is there a way to specifically identify the insert failure to a DB2
> > table due to duplicate index. I am geting "General Error". I am using
[quoted text clipped - 4 lines]
>
> robert

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...