Control file

LOAD DATA
 characterset ZHS16GBK
append

INTO TABLE XXTC_APINV_I_MRI_All

FIELDS TERMINATED BY '|'

OPTIONALLY ENCLOSED BY '"'

TRAILING NULLCOLS

(      
COMPANY_CODE CHAR "LTRIM(RTRIM(:COMPANY_CODE))"
,
LOCATION       CHAR "LTRIM(RTRIM(:LOCATION))"
,  
VENDOR_ID   CHAR "LTRIM(RTRIM(:VENDOR_ID))"
,
INVOICE_NUM   CHAR "LTRIM(RTRIM(:INVOICE_NUM))"
,
INVOICE_DATE   DATE "DDMMYYYY"
NULLIF INVOICE_DATE=BLANKS
,
LINE_AMOUNT   CHAR "LTRIM(RTRIM(:LINE_AMOUNT))"
,
INVHEAD_DESC   CHAR "LTRIM(RTRIM(:INVHEAD_DESC))"
,
TAX_CODE   CHAR "LTRIM(RTRIM(:TAX_CODE))"
,
INVOICE_TYPE   CHAR "LTRIM(RTRIM(:INVOICE_TYPE))"
,
INV_LINE_DESC    CHAR "LTRIM(RTRIM(:INV_LINE_DESC))"
,
ORG_ID   CHAR "LTRIM(RTRIM(:ORG_ID))"
)