Accessing AS/400 DB2 physical files with Java

15 pts.
Tags:
AS/400 development
DB2/400
Java
Java/400
JD Edwards (JDE)
JD Edwards World
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • GeethaNatarjan
    Thanks vandver, we used jt400.jar for accessing those physical files..
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following