Re: Record Level Classes or SQL Query classes

[Glenn Holmer <gholmer@xxxxxxxxxxxxxx>]

Sethi, Ramesh (US) wrote:
> 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