RE: Re[2]: Question using jdbc/jt400

From: MidRange

I looked into this earlier and it seemed to be more difficult to set
up - creating all the fields and stuff. Or am I just seeing it that
way because I already have the statement/resultset stuff set up?
<smile>

// Set up key and chain to file
key = new Object[] { item };
record = file.read(key);

// Change the field contents and update the record
record.setField("ITDESC", newDesc);
file.update(record);

I wrote a course comparing the two a while back, but in general it's

pretty

straightforward. You can find documentation on the standard JDBC stuff

just

about anywhere; it's pretty much industry standard. IBM has

documentation

on com.ibm.as400.access.KeyedFile and
com.ibm.as400.access.SequentialFile
for the RLA stuff.

Could I access this course? Thanks for the nudge - I guess I need to do
it...

The course is available from Rochester Initiative:

http://www.lab400.com/product_detail.asp?prod_id=200.

It's a little long in the tooth - it uses Visual Age for Java rather than
WDSC - but the concepts and the code are still perfectly valid.

Joe