How to download data from DB2/400 table

15 pts.
Tags:
DB2/400
Can someone tell me how does the unload utility work in DB2/400? I need to download data from a DB2 table to a text file.

Software/Hardware used:
AS400

Answer Wiki

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

Discuss This Question: 2  Replies

 
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
  • philpl1jb
    there are a lot of options.  The cpytoimpf is sometimes used. http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=%2Fdm%2Frbal3usingcpyto.htm 
    51,355 pointsBadges:
    report
  • TomLiotta
    The CPYTOIMPF command is made available on the AS/400 line to act as an "unload" facility. But you seem to need a "download" utility rather than "unload". The iSeries Access file transfer functions would seem to be a better choice. Do you have iSeries Access on your workstation? If not, what product do you have for connecting to the server? -- Tom
    125,585 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