Home > IT Answers > AS/400 > How to download data from DB2/400 table
smlegacy
15 pts.
 How to download data from DB2/400 table
DB2/400, unload utility
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
ASKED: January 23, 2013  11:50 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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 

philpl1jb
 44,220 pts.
 

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

TomLiotta
 108,360 pts.