Re: JDBC help

JDBC basics: http://java.sun.com/docs/books/tutorial/jdbc/

*
Michael_Schutte@xxxxxxxxxxxx wrote:

I'm just getting started with JDBC, does anyone know where I can get good
reference manuals for the methods.

While I have your attention, I want to write a procedure that will validate
that a record exists on a different machine.  I already have a procedure
that returns records back to the iSeries.

I was thinking that it would look something like this...

<code>
stmt = "select * from table";
If exists(stmt.executeQuery) { return true;}
else {return false;}
</code>

If that doesn't work, I'd imagine that I could just say     select top 1 *
from table   then check   rs.next

I'm just looking for the best performance on getting data from this
external machine.  Please advise...

Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
Visit us on the web! www.bobevans.com
We've built a better hotcake -- Stacked and Stuffed Hotcakes -- coming
January 11th!
For hotcake tips, interviews with our chefs and more, check out the Stacked
and Stuffed blog at http://imstuffed.blogspot.com