aspose file tools*
The moose likes JDBC and the fly likes Java and AS400 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Java and AS400" Watch "Java and AS400" New topic
Author

Java and AS400

Prasad Ballari
Ranch Hand

Joined: Sep 23, 2000
Posts: 149
Hi,
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.
prasad

------------------

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

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
Greenhorn

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:
http://www-1.ibm.com/servers/eserver/iseries/toolbox/
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...
Joel


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
Hi,
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.
Prasad

------------------

[This message has been edited by Prasad Ballari (edited June 05, 2001).]
Bacon
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: http://aspose.com/file-tools
 
subject: Java and AS400
 
Similar Threads
Question on SwA and SAAJ
Java and AS400
NoClassDefFoundError
Creating an AS400-Object
converting bigdecimal