Re: Accessing mainframe DB2 in Java.

Arne Vajhøj wrote:
> zalek wrote:
>> On Mar 22, 5:14 pm, Arne Vajhøj <a...@[EMAIL PROTECTED]
> wrote:
>>> zalek wrote:
>>>> 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?
>>> Usually (possible always) the JDBC driver will throw an SQLException
>>> if not success.
>>
>> Yes - I know - but I would like to know what exactly happen. For
>> example - if I try to access a table using a variable as a key - I
>> would like to know "not found conditions" occurred to display correct
>> message. If database was down - I would like to know it too. Is there
>> a way in a java world to find it?
> 
> e.getErrorCode() will give you SQLCODE number.

Duh.  You know I looked right at that in the Javadocs and because it 
didn't say "getVendorCode" I didn't read any further?  Ouch.