-- コミット件数(制限なし),エラー許容サイズ(制限なし)
OPTIONS(
ERRORS=2147483647,
DIRECT=Y,
MULTITHREADING=TRUE,
PARALLEL=Y,
COLUMNARRAYROWS=10000,
STREAMSIZE=16000000,
SKIP_INDEX_MAINTENANCE=TRUE,
BINDSIZE=100000000,
READSIZE=100000000
)

LOAD DATA

-- 文字コード(Shift-JIS)
CHARACTERSET JA16SJISTILDE

-- レコード区切り(LF)
INFILE '' "str '\n'"

INTO TABLE CH_T_SEIKY_T

-- APPEND
APPEND

-- カンマ区切り
FIELDS TERMINATED BY ","

TRAILING NULLCOLS
(
    SEIKY_NO,
    SEIKY_STAT,
    SEIKY_KEI_NO,
    TOKUSOKU_NO,
    SEIKY_YM,
    SEIKY_FIX_YMD,
    SEIKY_SBT_CD,
    KEI_SEIKY_WAY_CD,
    SEIKY_WAY_CD,
    KYOSEI_MADOGUCHI_FLG,
    SEIKY_REQ_YMD,
    DOFU_CD,
    SKS_HAKKO_SEQ,
    CUSTOMER_BARCODE,
    INFO_PATTERN_CD,
    DOHUBT_PATTERN_CD,
    SOHUS_AD_CD,
    SOHUS_PCD,
    SOHUS_STATE_NM,
    SOHUS_CITY_NM,
    SOHUS_OAZTSU_NM,
    SOHUS_AZCHO_NM,
    SOHUS_AD_BNCHIGO,
    SOHUS_ADRTTM,
    SOHUS_ADRRM,
    SOHUS_TELNO,
    SOHUS_NM,
    SOHUS_BKM,
    SOHUS_TNTSHA_NM,
    SHS_HOJIN_SBT_CD,
    SHS_HOJIN_ZENGO_SHITEI_CD,
    SHS_KANA,
    SOHUS_MLAD,
    SKHK_SVKEI_STAT_CD,
    SKHK_SVKEI_DLRE_SKBT_CD,
    SEIKYUS_HAKKO_YH,
    NEXT_SEIKY_WAY_DIV,
    RECEIPT_AMNT_OUTPUT_UM,
    PAY_KIGEN_YMD,
    SEIKYUS_HIKINUKI_FLG,
    SEIKYUS_HAKKO_TG_FLG,
    SEIKYUS_HAKKO_YMD,
    SEIKY_AMNT_ADJ_YMD,
    SEIKY_AMNT_CHGE_YMD,
    SEIKY_CL_YMD,
    BANK_CD,
    BANK_SHITEN_CD,
    YOKIN_SHUMOKU_CD,
    KOZA_NO,
    NEW_CD,
    TSUCHO_SYMBOL,
    TSUCHO_NO,
    KOZA_MEIGIN_KANA,
    KHRI_RSLT_RTN_YMD,
    KHRI_RSLT_CD,
    FLRLMT_CHOK_FLG,
    CRECARD_COMP_CD,
    CRECARD_NM_KANA,
    CRECARD_NM_ROMAJI,
    AUTHORI_RSLT_CD,
    MEMBSTR_NO_15,
    CRECARD_NO,
    CRECARD_YK_KIGEN,
    CREDIT_KOKAN_CD,
    DEAL_YMD,
    SALES_AUTHORI_JSSI_DTM,
    AUTHORI_SHONIN_NO,
    DEAL_SKBT_NO,
    SALES_DENPYO_NO,
    SHANAIUSE_SKBT_FLG,
    EAN_BARCODE,
    EAN_MAKER_CD,
    EAN_TRAT_LIMIT_YMD,
    OCR_BARCODE,
    ADD_DTM,
    ADD_OPEACNT,
    UPD_DTM,
    UPD_OPEACNT,
    DEL_DTM,
    DEL_OPEACNT,
    MK_FLG,
    ADD_UNYO_YMD,
    ADD_TRN_ID,
    UPD_UNYO_YMD,
    UPD_TRN_ID,
    DEL_UNYO_YMD,
    DEL_TRN_ID
)