如題
這里出現了幾個問題，各位大神看看，有解不
匯出的陳述句
db2 "EXPORT TO ${_pathaddss}/IACI.txt of DEL select TABLENAME,CLAIMSEQUENCENO,CONFIRMSEQUENCENO,RECOVERYCODE from ZBTABLE_PK"
下面 是 TXT 里的資料 ：
"A","50PICC370015001439865885172131","",""
"B","50PICC370015001439865885172131 ","02PICC370015001439865115632111 ",""
"C","50PICC370015001439865885172131 ","02PICC370015001439865115632111 ",""
"D","50PICC370015001439865885172131 ","",""
"E","50PICC370015001439865885172131 ","",""
"F","50PICC370015001439865885172131 ","",""
"D","50PICC370015001439865885172131 ","",""
資料還有重復的
腳本陳述句：
eecho '定核損車輛配件明細表'
_DINGCHEMINGNO=`db2 -x "select ClaimQueryNo from IALVEHICLEFITTING where ClaimQueryNo = '${j}'"`
db2 "insert into ZBTABLE_PK values ('IALVEHICLEFITTING','${_DINGCHEMINGNO}','','')"
db2 "insert into ZBTABLE_PK values ('IALVEHICLEFITTINGHis','${_DINGCHEMINGNO}','','')"
匯出的txt 資料 ：
"IALVEHICLEFITTING","50PICC370018001516156153150100 50PICC370018001516156153150100 ","",""
希望大神指點下啊
uj5u.com熱心網友回復：
方法1：在Select陳述句欄位前添加 trim(欄位)，去除空格；使用distinct 欄位，去除重復。方法2：使用UE或 NotePad++ 等富文本編輯器處理文本，使用匹配空格+后引號替換去除空格；使用編輯>行操作>排序，再去除重復。
編輯器不同，個別選單名稱也大同小異，具體工具再百度，這里提供一個思路。
uj5u.com熱心網友回復：
匯出IACI.txt后，cat IACI.txt | sed -e "s/ //g">IACI_1.txt。IACI.txt 是源檔案，IACI_1.txt 是去空后的重定向檔案。 cat 這句直接加在匯出陳述句db2那句后面，放shell里，一起執行即可轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/84050.html
標籤：DB2
上一篇：如何寫陳述句使查詢每隔十五分鐘取一條記錄，且該記錄的列是十五分鐘內所有記錄的平均值
下一篇：Hive正則提取連續數字成字串