分类: DB2/Informix
2008-04-13 21:31:06
常用的使用语法:
onunload和onload
导出表
onunload -t /20070615/salegoods4 -b 128 -s 8192000 dbshop:sale4
导入表
onload -t /backup/salegoods4 -b 128 -s 8192000 -d datadbs02 dbshop:sale4
unload和load
导出表
unload to /backup/sale.txt select * from sale;
导入表
load from /home/informix/sale.txt insert into sale;
导入表如果在当前目录下也可以如下执行:
load from sale.txt insert into sale;