DB2 to Text File Conversion and Transfer

20 pts.
Tags:
AS/400 DB2
DB2
DB2 Implementation
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??

Answer Wiki

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

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
<a href=”http://www.brucevining.com/”>http://www.brucevining.com/</a>
Integrated solutions for the System i user community

Discuss This Question:  

 
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

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