Fetching DB2 data from IBM i using Java
I need to fetch DB2 data from user libraries on an IBM i machine using Java. I'm using JTOpen400. Can anyone please he开发者_如何学JAVAlp?
You have to rephrase your question. RPGLE files does not exist on an iSeries. Everything is a DB2 table (which can be used with RPGLE offcourse).
If you have JTOpen400, then I advice to use JDBC. With JDBC the iSeries is a regular DB2 database server. It works like any other database server. Just follow the JDBC guidelines as describes in many books, manuals and websites.
Check SequentialFile for this. Remember to set the record format, and then you can pick out the fields for each line as you iterate them.
You can use JDBC (driver provided by JT400) to access DB2/400 files on the iSeries just like any other database.
The JDBC URL would be something like jdbc:as400://system-name/default-schema;properties
See http://javadoc.midrange.com/jtopen/com/ibm/as400/access/AS400JDBCDriver.html for more information.
精彩评论