Re: Accessing mainframe DB2 in Java.

On Mar 22, 5:14 pm, Arne Vajh=F8j <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=3D0), not found (sqlcode =3D +100),
> > duplicates (sqlcode=3D803) and more.
> > How do you check for this conditions in Java?
>
> Usually (possible always) the JDBC driver will throw an SQLException
> if not success.
>
> Arne

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?

Thanks,

Zalek