If you use JDBC, you can use the toolbox JDBC drivers to connect to the AS/400 from anywhere. If you are running your servlets on the AS/400, you can configure your servlet to use the native DB2 JDBC drivers instead of the toolbox drivers for faster access. (Not sure how it compares to record level access- I imagine record level performs faster). Another advtange of JDBC is that your servlet will likely run on any java platform and connect to any database, depending on the SQL that you use instead.
Interesting about how you must connect as QTMHHTTP to bypass TCP/IP on the 400 -- I did not know that.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.