Re: Accessing mainframe DB2 in Java.

zalek wrote:
> Hello,
> 
> I am a mainframe Cobol programmer (yes - Cobol programmers are still
> around, mostly in caves) and I am writing a java code to access DB2.
> In a Cobol world after each SQL command we are checking for return
> conditions like success (sqlcode=0), not found (sqlcode = +100),
> duplicates (sqlcode=803) and more.
> How do you check for this conditions in Java?
> 
> Thanks,
> 
> Zalek

I'm going to guess:

I see SQLException has a constructor that takes a vendor specific return 
code ("vendorCode").  I think you'll have to either 1) parse the 
toString() result (or similar string result) or 2) use reflection to 
peek at the internal vendorCode variable.

Ugly as it is, I think the second method might actually be more reliable.