Re: Record Level Classes or SQL Query classes

We have to decide whether we want to use Record Level Classes or SQL
Query classes to interact with AS400 physical/logical files. Since we
are new to this stuff, we not sure which is better than the other.

Any inputs from the group members, specially pros and cons of the above
2 approaches will be highly appreciated.

We generally find JDBC to be fast enough except when doing a lot
of updates or inserts in a row, in which case we prefer to use
record level access.  JDBC is a lot easier to code, even if you
are familiar with the native AS/400 filesystem.

In some cases, we have chosen a third option: RMI.  We run an
RMI server on both of our '400s for frequently-used "library"
methods that get called a lot and can benefit from the speed.

--
____________________________________________________________
Glenn Holmer                          gholmer@xxxxxxxxxxxxxx
Programmer/Analyst                       phone: 414-908-1809
Weyco Group, Inc.                          fax: 414-908-1601