数据文件导出格式
table t
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
a SYSIBM CHARACTER 8 0 No
b SYSIBM CHARACTER 21 0 No
c SYSIBM DECIMAL 20 0 No
d SYSIBM DECIMAL 20 0 No
插入一条记录
SETTLE_DT CARD_NO TRANS_NUM TRANS_AT
--------- --------------------- ---------------------- ----------------------
20080801 111111 00001111111111111111. 99999999999999999999.
db2 "export to a.txt of del select * from t"
导出这条数据
"20080801","111111 ",+00001111111111111111.,+99999999999999999999.
现在导出数据想得到:
"20080801","111111 ",1111111111111111,99999999999999999999
导出语句该如果写
急