sqlload能清空表的数据吗？

Question

sqlload能清空表的数据吗？
在ctl控制文件中怎么写这个语句？谢谢

Answer 1

load data
infile  "FILENAME" 
into table TABLENAME truncate
...

Answer 2

我的ctl文件内容如下：
load data
replace into table TP_AMEDRL0000
fields terminated by '|+|' 
(    --字段名称
    CUSTNBR ,
    ATA_FIXED_DATA_NAME_LINE_1_001 ,
    CUST_NAME_ADDR_DATA_USER_4_001 ,
    CUST_NAME_ADDR_DATA_DOB_001    ,
    NAME_ADDR_DATA_USER_DEMO_3_001 ,
    UST_NAME_ADDR_DATA_USER_12_001 ,
    CUST_NAME_ADDR_DATA_USER_1_001 ,
    MOBILEPH                       ,
    ST_NAME_ADDR_DATA_CNTRY_CD_001 ,
    CR_CLASS             ,
    VIP_STATUS           ,
    CUST_NAME_ADDR_DATA_ADDR_1_001 ,
    CUST_NAME_ADDR_DATA_ADDR_2_001 ,
    STATUS                         ,
    OPEN_DATE                      ,
    OPERATION_TYPE                 ,
    BITEM_ASSET                    ,
    QURITEM_ASSET                  ,
    FINAN_BALANCE                  ,
    Flag      
)我想在导入文件内容之前先清空表TP_AMEDRL0000的数据，如何写这个命令？

Answer 3

truncate参数在这里起什么作用啊？

Answer 4

load data
replace into table TP_AMEDRL0000
fields terminated by '|+|' 
(    --字段名称
    CUSTNBR ,
    ATA_FIXED_DATA_NAME_LINE_1_001 ,
    CUST_NAME_ADDR_DATA_USER_4_001 ,
    CUST_NAME_ADDR_DATA_DOB_001    ,
    NAME_ADDR_DATA_USER_DEMO_3_001 ,
    UST_NAME_ADDR_DATA_USER_12_001 ,
    CUST_NAME_ADDR_DATA_USER_1_001 ,
    MOBILEPH                       ,
    ST_NAME_ADDR_DATA_CNTRY_CD_001 ,
    CR_CLASS             ,
    VIP_STATUS           ,
    CUST_NAME_ADDR_DATA_ADDR_1_001 ,
    CUST_NAME_ADDR_DATA_ADDR_2_001 ,
    STATUS                         ,
    OPEN_DATE                      ,
    OPERATION_TYPE                 ,
    BITEM_ASSET                    ,
    QURITEM_ASSET                  ,
    FINAN_BALANCE                  ,
    Flag      
)
replace  -- 原先的表有数据 原先的数据会全部删除