DB2 to Text File Conversion and Transfer

20 pts.
Tags:
AS/400 DB2
IBM DB2
iSeries database
I have created a Text File from my AS/400 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

Discuss This Question: 1  Reply

 
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
  • ToddN2000
    Another option is to use a DDM file. Then you can use this in a CL program if this is to be more than just a one-time transfer.
    13,310 pointsBadges:
    report

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