Home > IT Answers > Database > Export in db2 iseries
Hn
25 pts.
 Export in db2 iseries
CSV, DB2, iSeries
i want to export query output to a csv file on iseries ..can anyone tell me how to do that

Software/Hardware used:
ASKED: September 9, 2008  12:23 PM
UPDATED: September 9, 2008  8:44 PM
RELATED QUESTIONS
Answer Wiki:
Hello, Client Access has a built in utility for Excel that brings the data transfer utility directly into Excel. If you are in Excel, click on Tools, Add-ins, then click on browse and go to C:Program FilesIBMClient AccessSharedcwbtfxla. select it. An option of iSeries data access will apear in your add ins. Check this option and hit ok. you will see a little icon appear on the very top left hand side which looks like an open book. Now data transfer is part of your excel interface permenantly. Transfer away. That works both to and from AS/400. Hope this helps...
Last Wiki Answer Submitted:  September 9, 2008  1:48 pm  by  Tpinky   4,165 pts.
All Answer Wiki Contributors:  Tpinky   4,165 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

Actually in our java application we are creating one msdos .bat file on the fly which exports the table data to csv file using db2 export command .I need to know how can we do the same on iseries.Well thanx for ur reply ,i have very less knowledge of iseries. We have developed our application on windows but we need to deploy it on AS/400 server

Hn
 25 pts.
 

We recently had an author provide a CL program to do this: Automated CL method of moving a query from AS/400 to Excel

Leah Rosin
 490 pts.