Question

  Asked: Mar 1 2008   2:50 PM GMT
  Asked by: Gvdsswami


DB2 to Text File Conversion and Transfer


DB2 Implementation, AS/400 DB2, DB2, iSeries database

I have craeted a Text File from my AS400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this??

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



If your intent is to move a file from one iSeries (or System i) to another iSeries/System i then I'm not sure why you are going through the intermediate step of a text file. But in any case, if you have TCP/IP up between the two systems then FTP is the way to go.

If you just want the data, ftp the file.

If you want the database:
Create a save file on the source system
Save the database to the save file
Create a save file on the target system
FTP the save file to the target system in binary mode
Restore the database on the target system

If you're not familiar with FTP let us know. We can guide you through the steps (there aren't many). If you don't have TCP/IP between the two systems, let us know what options you do have in transferring data between the two systems (SNA, tape, etc).

Bruce Vining
http://www.brucevining.com/
Integrated solutions for the System i user community
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Database and AS/400.

Looking for relevant Database Whitepapers? Visit the SearchOracle.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register