Question

DB2里面export怎么用

例如，要将XXX数据导出，应该怎么输入命令shell里面，我用的是linux

Answer 1

shell里头之间就支持db2命令。可以跟你在CLP里一样写~

Answer 2

db2 "EXPORT TO XXX.DEL OF DEL SELECT * FROM XXX"

Answer 3

connect to <database> user xxxx using xxxx
db2 export to /tmp/xxxx.txt of del select * from <schema>.<table name> where <condition>