File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Java and AS400 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Java and AS400" Watch "Java and AS400" New topic

Java and AS400

Prasad Ballari
Ranch Hand

Joined: Sep 23, 2000
Posts: 149
Anybody knows how to get data from AS400 i.e from DB2 database to Win NT 4.0 platform is any software readable format (.txt or XML)
Thanks in advance.


[This message has been edited by Prasad Ballari (edited June 05, 2001).]
Carl Trusiak

Joined: Jun 13, 2000
Posts: 3340
Since the data is in a Database, you can use JDBC to read it into any format that you want. I'm going to move this post to the JDBC forum.
Anyone know where he can get the JDBC drivers for DB2?

Hope This Helps
Carl Trusiak, SCJP2

I Hope This Helps
Carl Trusiak, SCJP2, SCWCD
Julio Lopez

Joined: Nov 14, 2000
Posts: 28
The JDBC drivers are part of IBM's AS/400 Toolbox for Java. JTOpen is the open source version of Toolbox for Java, you can get it at:
You will need to register first. If all you want is to get the data into a text file you might want to use Client Access and do a "Data Transfer from AS/400".
Julio Lopez
M-Group Systems
Joel Cochran
Ranch Hand

Joined: Mar 23, 2001
Posts: 301
If you are familiar with the AS/400, the following will help you:
1: As Julio said, you can use Client Access, but you can also use either of the two following commands from the 400 itself: CPYTOPCD or CPYIMPF.
2: If you have access to an AS/400 with a fairly recent version of the Operating System, you will find that the Toolbox for Java is free and may already be accessible through the IFS.
3: The JDBC route is a snap. Moving the files from one machine to the other is not difficult but requires a certain level of familiarity with the 400.
Good Luck!
I'm a soldier in the NetScape Wars...

Wait a minute, I'm trying to think of something clever to say...<p>Joel
Prasad Ballari
Ranch Hand

Joined: Sep 23, 2000
Posts: 149
Thanks Julio for site address.
Thanks to every one, As i am brand new to As/400 i can't understand the full details.Can u pls expain me in detail.
Thanks in advace.


[This message has been edited by Prasad Ballari (edited June 05, 2001).]
Ranch Hand

Joined: Jul 14, 2004
Posts: 305
I realize this is an older post, however, there is a good book available for this topic. "Java Application Strategies for the AS400" by Don Denoncourt, published by Mid-Range computing.
I agree. Here's the link:
subject: Java and AS400
jQuery in Action, 3rd edition