Is therea tool or a way to export CSV ot text files?
We are trying to create a local backup of the one of our library before it's decommissioned.Do you know of any tool/way to export all the data as csv or text files ? The data will be migrated to a Unix platform. Thanks
Software/Hardware used:
Software/Hardware used:
ASKED:
February 14, 2006 12:41 PM
UPDATED:
November 29, 2009 9:50 PM
RELATED QUESTIONS
- How to remove specific lines from a text files using either vbs or bat.
- Data report from iSeries to a CSV format need page breaks and colors
- How do I convert PST file to something I can search by text all contents?
- Extract data from dmp-file without Oracle
- How to Import Data from a .CSV or .XLSX file to an AS400 file?
Answer Wiki:
Use the CPYTOIMPF "Copy To Import File" command to copy DB2 files to IFS files.
===============================================
Is the app being migrated along with the data? Or are you just looking to decommission the app and store the data for historical reference? The CPYTOIMPF command is a way to put data into a .CSV (or other delimiter) format. There may be alternatives such as the Qshell db2 utility.
If the app itself is being migrated, then maybe something more like a JDBC extract would be appropriate. There might be ways to populate the new database more or less directly.
Tom
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
