DB2 export 與 import 相關操作
db2 "export to employee.del of del messages emp.msg select * from employee "
db2 "export to employee_2.del of del modified by Chardel'' messages emp_2.msg select * from employee"
db2 "export to employee_3.ixf of ixf messages emp_3.msg select * from employee"
db2 "export to emp_resume.del of del lobs to /data/lobs modified by lobsinfile select * from emp_resume"
db2 "export to emp_resume_2.del of del lobs to /data/lobs2 modified by lobsinsepfiles select * from emp_resume"
db2 "import from order.txt of del allow write access commitcount 10 insert into vps.order"
db2 "export to s1.t1.ixf of ixf messages s1.t1.msg select * from s1.t1"
db2 "import from s1.t1.ixf of ixf insert into s1.t1"
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22661144/viewspace-1477204/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- DB2 export and importDB2ExportImport
- statistics的export與import!ExportImport
- export/importExportImport
- 關於 ES6 的 import 與 export 的思考ImportExport
- 新手關於import/export的理解ImportExport
- DB2 統計資訊與重組相關操作DB2
- mysql export & importMySqlExportImport
- mysql import and exportMySqlImportExport
- DB2資料的匯入(Import) 匯出(Export)(Load)DB2ImportExport
- import、require 、export、export default、exports、module exportsImportUIExport
- ES6 import exportImportExport
- oracle Export/Import工具使用OracleExportImport
- DLL的Export和ImportExportImport
- module.exports 、 exports 和 export 、 export default 、 importExportImport
- Import Error: cannot import name ‘export_saved_modelImportErrorExport
- Export/import Datas To/from a Csv FileExportImport
- import,export的支援[nodejs]ImportExportNodeJS
- full database export and import(實戰)DatabaseExportImport
- DataPump Export/Import Of LOBs Are Not Executed in ParallelExportImportParallel
- oracle Export and Import 簡介(轉)OracleExportImport
- Data Utilities : Export and Import Utilities (57)ExportImport
- Export And Import Between Different Oracle VersionsExportImportOracle
- Python import相關內容區別介紹( import *** as 、from***import )PythonImport
- ES6 module模組 import exportImportExport
- 1nd round export and import errorExportImportError
- DB2 export詳解DB2Export
- db2 export loadDB2Export
- DB2日誌相關DB2
- DB2 LOAD相關DB2
- Oracle 12c full transportable export & importOracleExportImport
- DB2 import詳解DB2Import
- JS/TS 的 import 和 export 用法小結JSImportExport
- node識別es6的 import/exportImportExport
- MongoDB相關操作MongoDB
- 日期操作相關
- java與作業系統相關的操作Java作業系統
- html 列印相關操作與實現詳解HTML
- DB2 修改表列相關屬性DB2