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

-- APPEND
APPEND

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

TRAILING NULLCOLS
(
    SEIKY_NO,
    SEIKY_KEI_NO,
    SEIKY_YM,
    SEIRI_NO,
    SVC_KEI_NO,
    PRC_GRP_CD,
    PCRS_CD,
    PRC_SVC_CD,
    PRC_KMK_CD,
    GSAN_SEIKY_YM,
    USE_STAYMD,
    USE_ENDYMD,
    AMNT,
    PRC_TEISE_ADD_FLG,
    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,
    SVC_DTL_SKBT_NO,
    SEIKY_UCWK_NO
)