Home > IT Answers > AS/400 > Accessing AS/400 DB2 physical files with Java
GeethaNatarjan
15 pts.
 Accessing AS/400 DB2 physical files with Java
AS/400 development, DB2/400, Java, Java/400, JD Edwards World, JDE, ODBC, Physical File
Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I am unable to get the correct ODBC driver. I am looking for correct driver to access the data. If some one has done this already, please help me.

Software/Hardware used:
ASKED: March 17, 2009  7:00 AM
UPDATED: May 20, 2009  12:58 PM
RELATED QUESTIONS
Answer Wiki:
Here is link to the Java toolbox for AS/400 JDBC page. From here, you should be able to answer your questions. I wrote about this stuff in 2002 and I think it is still valid so check www.itjungle.com for articles on the subject. select the AS/400 Guru newsletter and scroll to the bottom (not sure how well the search works) and you will see article on access RPG and the AS/400 from java. Here is the link to the Java tookbox for java http://www-03.ibm.com/systems/i/software/toolbox/faqjdbc.html Hope this helps
Last Wiki Answer Submitted:  March 17, 2009  2:36 pm  by  Kvandever   15 pts.
All Answer Wiki Contributors:  Kvandever   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks vandver,

we used jt400.jar for accessing those physical files..

GeethaNatarjan
 15 pts.