-- コミット件数(制限なし),エラー許容サイズ(制限なし)
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_SAIKEN

-- APPEND
APPEND

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

TRAILING NULLCOLS
(
    SAIKEN_NO,
    SEIKY_KEI_NO,
    SVC_KEI_NO,
    SAIKEN_YM,
    SAIKEN_STAT,
    SEIKY_WAY_CD,
    PAY_KIGEN_YMD,
    CHG_PAY_KIGEN_YMD,
    SEIKY_SBT_CD,
    SAIKEN_TORIATSU_CD,
    SAIKEN_FIX_YMD,
    RCNT_SAIKEN_JUTO_YMD,
    SAIKEN_ADJ_YMD,
    SAIKEN_CHG_YMD,
    JUTO_FIN_YMD,
    SAIKEN_SHOKYAKU_YMD,
    SHOKYAKU_RSN_CD,
    HSHIAK_PRC_TEISE_UM,
    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
)