This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Java and AS400

 
Prasad Ballari
Ranch Hand
Posts: 149
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3341
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Julio Lopez
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 301
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Prasad Ballari
Ranch Hand
Posts: 149
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 305
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic