本示例中,导出数据文件为普通文本格式,同时设置字段分隔符为'|'。
$ ./db2to8a -D'test' -u'db2inst1' -p'db2inst1' -q"select * from t1"
-m'0' -e'|'
-f'data1.txt'
you machine is Little endian!
Connecting to test...
GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
573
Connected to test.
--- unload [text file] mode ---
--- field="|" ---
0 rows exported at 2013-08-30 13:40:47
6 rows exported at 2013-08-30 13:40:47
output file t13.dat10 closed
export:
6 rows.
export:
4 columns.
export time: