資料匯入一問題(急)
一個目錄底下約有15000個檔案，檔案名稱如下：
-rwxr-xr-x 1 nobody nobody 59425 Mar 15 14:09 2008-12-24-HEDC_PIMCURE.ixf.gz
-rwxr-xr-x 1 nobody nobody 11192 Mar 15 14:09 2008-12-24-HEDC_PIRWK.ixf.gz
-rwxr-xr-x 1 nobody nobody 7254 Mar 15 14:09 2008-12-24-HEDC_PIRWKINSP.ixf.gz
-rwxr-xr-x 1 nobody nobody 7293 Mar 15 14:09 2008-12-24-HEDC_PITHICK.ixf.gz
-rwxr-xr-x 1 nobody nobody 77036 Mar 15 14:09 2008-12-24-HEDC_RUBBING.ixf.gz
-rwxr-xr-x 1 nobody nobody 21420 Mar 15 14:09 2008-12-24-HEDC_VNRCHK.ixf.gz
-rwxr-xr-x 1 nobody nobody 6840 Mar 15 14:09 2008-12-25-HEDC_1STCUT.ixf.gz
-rwxr-xr-x 1 nobody nobody 7119 Mar 15 14:09 2008-12-25-HEDC_1STGRIND.ixf.gz
-rwxr-xr-x 1 nobody nobody 154707 Mar 15 14:09 2008-12-25-HEDC_2NDCLN.ixf.gz
-rwxr-xr-x 1 nobody nobody 104912 Mar 15 14:09 2008-12-25-HEDC_2NDCUT.ixf.gz
-rwxr-xr-x 1 nobody nobody 67474 Mar 15 14:09 2008-12-25-HEDC_2NDEGINSP.ixf.gz
-rwxr-xr-x 1 nobody nobody 120613 Mar 15 14:09 2008-12-25-HEDC_2NDGRIND.ixf.gz
-rwxr-xr-x 1 nobody nobody 13771 Mar 15 14:09 2008-12-25-HEDC_CELLGAP.ixf.gz
-rwxr-xr-x 1 nobody nobody 7111 Mar 15 14:09 2008-12-25-HEDC_MSCOPE.ixf.gz
-rwxr-xr-x 1 nobody nobody 15277 Mar 15 14:09 2008-12-25-HEDC_ODCARC.ixf.gz
-rwxr-xr-x 1 nobody nobody 10415 Mar 15 14:09 2008-12-25-HEDC_ODCARCOVEN.ixf.gz
-rwxr-xr-x 1 nobody nobody 9295 Mar 15 14:09 2008-12-25-HEDC_ODCSPASPR.ixf.gz
-rwxr-xr-x 1 nobody nobody 12470 Mar 15 14:09 2008-12-25-HEDC_ODFCST.ixf.gz
-rwxr-xr-x 1 nobody nobody 15370 Mar 15 14:09 2008-12-25-HEDC_ODTARC.ixf.gz
-rwxr-xr-x 1 nobody nobody 10482 Mar 15 14:09 2008-12-25-HEDC_ODTARCOVEN.ixf.gz
請問一下有沒有辦法利用shell 別分將每一天的檔案進行gzip -d 之後再將 .ixf 利用IBM DB2 IMPORT 方式匯入
已建好資料庫當中。 有吧，不过处理字符串中的那些单引号，空值和主键外键真得很烦，可能都要case by case来处理
页:
[1]