Chinaunix

标题: 資料匯入一問題(急) [打印本页]

作者: 68930089 时间: 2009-03-16 14:08
标题: 資料匯入一問題(急)
一個目錄底下約有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 方式匯入
已建好資料庫當中。

作者: wrl 时间: 2009-03-30 18:32
有吧，不过处理字符串中的那些单引号，空值和主键外键真得很烦，可能都要case by case来处理

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)