#!/bin/bash
##############################################################
# システム名    ：eo顧客基幹システム
#
# サブシステム名：請求収納
#
# シェル名      ：未収債権情報抽出
#
# 機能          ：1.未収債権情報抽出
#
#(１)
#未収債権データを抽出し、未収債権情報を作成する。
#
#
# コマンド形式  ：EO60Y0120J0.sh
#
# 実行環境      ：.../app/shl
#
# 終了ステータス：ゼロ以外異常
#
# 特記事項      ：特になし
#
# 変更履歴      ：変更日      変更者       障害／仕様変更No.
# v3.00           2012/07/27  FJ）冨井     【ST2-2012-0001211】ヒープサイズ拡張
# v4.01           2013/03/18  FJ）広野     性能改善: アンロードの参照先スクリプト変更にともなう修正
# v4.02           2013/03/22  FJ) 狭間     【ST4-2013-0000233】性能改善の為、アンロード手順を見直し
# v4.03           2013/04/03  FJ) 狭間     【ST2-2013-0001650】性能改善の為、請求アンロードを統一
# v4.04           2013/04/08  FJ) 狭間     【ST4-2013-0000286】性能改善の為、アンロード並列化及び処理見直しと水平展開
# v4.05           2013/05/27  FJ) 前田     【TG1-2013-0000538】債権充当入金抽出不備による修正
# v4.06           2013/05/29  FJ) 前田     【TG1-2013-0000542】督促番号を請求スキーマから取得するように変更
# v4.07           2013/06/27  FJ) 藤田     【ST4-2013-0000479】性能改善 nkfの使用を廃止する。
# v5.00           2013/07/18  FJ) 足立原   【ST4-2013-0000514】性能改善 債権内訳アンロード並列化
# v5.01           2013/08/01  FJ) 後藤     【TG1-2013-0000733】督促番号を督促スキーマから取得するように変更
# v5.02           2013/08/01  FJ) 狭間     【TG1-2013-0000731】請求アンロードファイル（CHIFM186001）の項目追加に伴いbsortの指定サイズ変更
# v5.03           2014/06/16  FJ) 中作     【ST4-2014-0000016】性能改善 債権内訳
# v9.00.00        2014/06/05  FJ) 安井     【IT2-2014-0000167・OM-2014-0001880】
# v11.00.00       2014/11/19  FJ) 安井     【ST4-2014-0000077】性能改善
# v21.00.00       2015/12/14  FJ) 福山     【 OM-2015-0003141】性能改善 並列実行数の見直しとソート削除対応
# v54.00.00       2021/12/21  FJ)星野      【ANK-4069-00-00】EOL対応(バッチ・DBサーバリプレース対応)
##############################################################

##############################################################
# 環境変数定義
##############################################################

#
#---ツール格納場所
#
G_TOOLSH=.

#
#---環境変数定義Shell呼び出し
#
. EOK010110J0.sh

#
#---ＪＯＢ名
#
JOBNAME=`basename $0 | sed -e "s/\.sh//g"`

#
#---サービス（業務プロセス）
#
SVC=$JOBNAME

#
#---OPD
#
OPD=$1

#
#---業務で必要な変数定義
#
[ $# -eq 2 ] &&TAJUKIDO="_$2"

#---ワークファイル削除モード
WK_RM=true

#---運用日付取得
if [ "${OPD}" = "" ]; then
   . EOK010310J0.sh "BDATE"
else
   RSLT_OPEDATE="${OPD}"
fi

#---システム日時取得
. EOK010410J0.sh "1"
SYSDATE=${RSLT_SYSDATE}

#---マッチング処理でLeftjoinがNULL時に"を付けなくする（マッチング使用時は必須）
export ZTLQUOTES=''

##############################################################
# 業務処理
##############################################################
sh ${G_TOOLSH}/EOK010210J0.sh CS00025I $JOBNAME

#
#---パラメタ定義
#

P1="OPD=,"
P2="SVCCTL=JBSbatMultiServiceControl,"
P3="JOB=EO60Y0120J0,"
P4="IND1=CHIFM164.def,"
P5="INF1=${MID_DIR_CH}/CHIFM164001.csv,"
P6="IND2=,"
P7="INF2=,"
P8="OTD1=CHIFM068.def,"
P9="OTF1=${MID_DIR_CH}/CHIFM068008.csv,"
P10="OTD2=,"
P11="OTF2=,"
P12="TABLENAME=,"
P13="SQLKEY=,"
P14="SQLPARAM=,"
P15="ERRFILE=,"
P16="RECOVERY=,"
P17="BREAKPTN=,"
P18="FREE="
PARA="$P1$P2$P3$P4$P5$P6$P7$P8$P9$P10$P11$P12$P13$P14$P15$P16$P17$P18"

sh ${G_TOOLSH}/EOK010210J0.sh CS00027I $JOBNAME

#
#--- ファイル定義
#
#--- 入力ファイル
#- 請求アンロードファイル
INFILE_CHIFM186001=${MID_DIR_CH}/CHIFM186001.csv
INFILE_CHIFM186001_WRK=${MID_DIR_CH}/${JOBNAME}_CHIFM186001_BSORT_WK1.csv

#- 督促アンロードファイル
INFILE_CHIFM183002=${MID_DIR_CH}/CHIFM183002.csv

#--- 出力ファイル
OUTFILE=${MID_DIR_CH}/CHIFM164001.csv
# OM-2015-0003141 性能改善 マッチング処理の一本化 2015/12/14 福山 MOD START
#OUTFILE_WRK_01=${MID_DIR_CH}/${JOBNAME}_CHIFM164001_UNLOADER_WK_01.csv
#OUTFILE_WRK_02=${MID_DIR_CH}/${JOBNAME}_CHIFM164001_UNLOADER_WK_02.csv
#OUTFILE_WRK_03=${MID_DIR_CH}/${JOBNAME}_CHIFM164001_UNLOADER_WK_03.csv
#OUTFILE_WRK_04=${MID_DIR_CH}/${JOBNAME}_CHIFM164001_UNLOADER_WK_04.csv
OUTFILE_WRK_ALL=${MID_DIR_CH}/${JOBNAME}_CHIFM164001_UNLOADER_WK_ALL.csv
# OM-2015-0003141 性能改善 マッチング処理の一本化 2015/12/14 福山 MOD END

#--- 1.料金項目抽出変換マスタCH_M_PRC_KMK_CS_CHGE
SQLFILE_CH0401=${SQL_DIR}/CH_U_CH0401_10.sql
SQLFILE_CH0401_WRK=${SQL_DIR}/${JOBNAME}_CH_U_CH0401_10_UNLOADER_WK_1$TAJUKIDO.sql
SQLFILE_CH0401_WRK2=${SQL_DIR}/${JOBNAME}_CH_U_CH0401_10_UNLOADER_WK_2$TAJUKIDO.sql

CSVFILE_CH0401=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0401_10_UNLOADER_WK_1$TAJUKIDO.csv
CSVFILE_CH0401_WRK=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0401_10_UNLOADER_WK_2$TAJUKIDO.csv

#--- 2.債権内訳CH_T_SAIKEN_UCWK（Pあり）
SQLFILE_CH0021=${SQL_DIR}/CH_U_CH0021_03.sql
SQLFILE_CH0021_H=${SQL_DIR}/CH_U_CH0021_10.sql
SQLFILE_CH0021_WRK=${SQL_DIR}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_1$TAJUKIDO.sql
SQLFILE_CH0021_WRK2=${SQL_DIR}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_2$TAJUKIDO.sql
SQLFILE_CH0021_WRK_01=${SQL_DIR}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_01.sql
SQLFILE_CH0021_WRK_02=${SQL_DIR}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_02.sql
SQLFILE_CH0021_WRK_03=${SQL_DIR}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_03.sql
SQLFILE_CH0021_WRK_04=${SQL_DIR}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_04.sql

CSVFILE_CH0021=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_1$TAJUKIDO.csv
CSVFILE_CH0021_WRK=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_2$TAJUKIDO.csv
CSVFILE_CH0021_WRK_01=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_01.csv
CSVFILE_CH0021_WRK_02=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_02.csv
CSVFILE_CH0021_WRK_03=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_03.csv
CSVFILE_CH0021_WRK_04=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_04.csv
CSVFILE_CH0021_WRK_ALL=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_ALL.csv

#IT2-2014-0000167・OM-2014-0001880 ADD STA
CSVFILE_CH0021_WRK_STX=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_STX_2$TAJUKIDO.csv
CSVFILE_CH0021_WRK_STX_01=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0021_03_UNLOADER_WK_STX_01.csv
#IT2-2014-0000167・OM-2014-0001880 ADD END

#--- 3.請求債権関連CH_T_SEIKY_SKN_KNRN
SQLFILE_CH0041=${SQL_DIR}/CH_U_CH0041_01.sql
SQLFILE_CH0041_WRK=${SQL_DIR}/${JOBNAME}_CH_U_CH0041_01_UNLOADER_WK_1$TAJUKIDO.sql
SQLFILE_CH0041_WRK2=${SQL_DIR}/${JOBNAME}_CH_U_CH0041_01_UNLOADER_WK_2$TAJUKIDO.sql

CSVFILE_CH0041=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0041_01_UNLOADER_WK_1$TAJUKIDO.csv
CSVFILE_CH0041_WRK=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0041_01_UNLOADER_WK_2$TAJUKIDO.csv

#--- 5.入金CH_T_NYUKIN
SQLFILE_CH0111=${SQL_DIR}/CH_U_CH0111_01.sql
SQLFILE_CH0111_WRK=${SQL_DIR}/${JOBNAME}_CH_U_CH0111_01_UNLOADER_WK_1$TAJUKIDO.sql
SQLFILE_CH0111_WRK2=${SQL_DIR}/${JOBNAME}_CH_U_CH0111_01_UNLOADER_WK_2$TAJUKIDO.sql

CSVFILE_CH0111=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0111_01_UNLOADER_WK_1$TAJUKIDO.csv
CSVFILE_CH0111_WRK=${MID_DIR_CH}/${JOBNAME}_CH_U_CH0111_01_UNLOADER_WK_2$TAJUKIDO.csv

#--- 未収債権抽出
DEFFILE=${G_TOOLSH}/util/def/CH_CM_0019.def
DEFFILE_WRK=${G_TOOLSH}/util/def/${JOBNAME}_CH_CM_0019_MATCHING_WK_1$TAJUKIDO.def
DEFFILE_WRK_01=${G_TOOLSH}/util/def/${JOBNAME}_CH_CM_0019_MATCHING_WK_01.def
DEFFILE_WRK_02=${G_TOOLSH}/util/def/${JOBNAME}_CH_CM_0019_MATCHING_WK_02.def
DEFFILE_WRK_03=${G_TOOLSH}/util/def/${JOBNAME}_CH_CM_0019_MATCHING_WK_03.def
DEFFILE_WRK_04=${G_TOOLSH}/util/def/${JOBNAME}_CH_CM_0019_MATCHING_WK_04.def

#
#--- 各ファイルの存在チェックを行う
#
if [ ! -r $INFILE_CHIFM186001 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($INFILE_CHIFM186001) "
    echo $JOBNAME " File is nonexist($INFILE_CHIFM186001) "
    exit ${G_RTN_ERROR}
fi
if [ ! -r $INFILE_CHIFM183002 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($INFILE_CHIFM183002) "
    echo $JOBNAME " File is nonexist($INFILE_CHIFM183002) "
    exit ${G_RTN_ERROR}
fi
if [ ! -r $SQLFILE_CH0401 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_CH0401) "
    echo $JOBNAME " File is nonexist($SQLFILE_CH0401) "
    exit ${G_RTN_ERROR}
fi
if [ ! -r $SQLFILE_CH0021 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_CH0021) "
    echo $JOBNAME " File is nonexist($SQLFILE_CH0021) "
    exit ${G_RTN_ERROR}
fi
if [ ! -r $SQLFILE_CH0041 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_CH0041) "
    echo $JOBNAME " File is nonexist($SQLFILE_CH0041) "
    exit ${G_RTN_ERROR}
fi
if [ ! -r $SQLFILE_CH0111 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_CH0111) "
    echo $JOBNAME " File is nonexist($SQLFILE_CH0111) "
    exit ${G_RTN_ERROR}
fi

# 債権内訳のアンロードが単体処理だと長時間の為、範囲を４つに分割してアンロードする
# ----債権内訳の分割アンロード用データ取得年月設定
# 年月変数の値を設定(年月はyyyymm形式)
#   MONTH_00 :当月
#   MONTH_01 :前月
#   MONTH_02 :先々月
#   MONTH_12 :12ヵ月前
#   MONTH_13 :13ヵ月前
#   MONTH_24 :24ヵ月前
#   ※末尾の数字が当月から何カ月遡っているかを表す
# ANK-4069-00-00対応 20211221 星野 MOD START
#OPEDATE_YM=`echo ${RSLT_OPEDATE} | cut -c0-6`
OPEDATE_YM=`echo ${RSLT_OPEDATE} | cut -c1-6`
# ANK-4069-00-00対応 20211221 星野 MOD END
TARGET_DATE=${OPEDATE_YM}01
MONTH_00=$(date +%Y%m --date "${TARGET_DATE}")
MONTH_01=$(date +%Y%m --date "${TARGET_DATE} 1 month ago")
MONTH_02=$(date +%Y%m --date "${TARGET_DATE} 2 month ago")
MONTH_12=$(date +%Y%m --date "${TARGET_DATE} 12 month ago")
MONTH_13=$(date +%Y%m --date "${TARGET_DATE} 13 month ago")
MONTH_24=$(date +%Y%m --date "${TARGET_DATE} 24 month ago")

#
#--- 【SQLPARAM】
#１．バッチ運用日：バッチ運用日
#　　OPE_DATE="'${RSLT_OPEDATE}'"
cp -f ${SQLFILE_CH0401} ${SQLFILE_CH0401_WRK}
sed -i -e "s%\:OPE_DATE%'${RSLT_OPEDATE}'%"  ${SQLFILE_CH0401_WRK}

cp -f ${SQLFILE_CH0021_H} ${SQLFILE_CH0021_WRK_01}
#20140527 sed -i -e "s/CH0011.SAIKEN_YM = CH0021.SAIKEN_FIX_YM/CH0021.SAIKEN_FIX_YM IN ('${MONTH_01}','${MONTH_00}') /" ${SQLFILE_CH0021_WRK_01}
sed -i -e "s/:CH0011.SAIKEN_YM/CH0011.SAIKEN_YM IN ('${MONTH_01}','${MONTH_00}') /" ${SQLFILE_CH0021_WRK_01}
sed -i -e "s/:CH0021.SAIKEN_FIX_YM/CH0021.SAIKEN_FIX_YM IN ('${MONTH_01}','${MONTH_00}') /" ${SQLFILE_CH0021_WRK_01}

cp -f ${SQLFILE_CH0021_H} ${SQLFILE_CH0021_WRK_02}
#20140527 sed -i -e "s/CH0011.SAIKEN_YM = CH0021.SAIKEN_FIX_YM/CH0021.SAIKEN_FIX_YM BETWEEN '${MONTH_12}' AND '${MONTH_02}' /" ${SQLFILE_CH0021_WRK_02}
sed -i -e "s/:CH0011.SAIKEN_YM/CH0011.SAIKEN_YM BETWEEN '${MONTH_12}' AND '${MONTH_02}' /" ${SQLFILE_CH0021_WRK_02}
sed -i -e "s/:CH0021.SAIKEN_FIX_YM/CH0021.SAIKEN_FIX_YM BETWEEN '${MONTH_12}' AND '${MONTH_02}' /" ${SQLFILE_CH0021_WRK_02}

cp -f ${SQLFILE_CH0021} ${SQLFILE_CH0021_WRK_03}
#20140527 sed -i -e "s/CH0011.SAIKEN_YM = CH0021.SAIKEN_FIX_YM/CH0021.SAIKEN_FIX_YM BETWEEN '${MONTH_24}' AND '${MONTH_13}' /" ${SQLFILE_CH0021_WRK_03}
sed -i -e "s/:CH0011.SAIKEN_YM/CH0011.SAIKEN_YM BETWEEN '${MONTH_24}' AND '${MONTH_13}' /" ${SQLFILE_CH0021_WRK_03}
sed -i -e "s/:CH0021.SAIKEN_FIX_YM/CH0021.SAIKEN_FIX_YM BETWEEN '${MONTH_24}' AND '${MONTH_13}' /" ${SQLFILE_CH0021_WRK_03}

cp -f ${SQLFILE_CH0021} ${SQLFILE_CH0021_WRK_04}
#20140527 sed -i -e "s/CH0011.SAIKEN_YM = CH0021.SAIKEN_FIX_YM/CH0021.SAIKEN_FIX_YM < '${MONTH_24}' /"  ${SQLFILE_CH0021_WRK_04}
sed -i -e "s/:CH0011.SAIKEN_YM/CH0011.SAIKEN_YM < '${MONTH_24}' /"  ${SQLFILE_CH0021_WRK_04}
sed -i -e "s/:CH0021.SAIKEN_FIX_YM/CH0021.SAIKEN_FIX_YM < '${MONTH_24}' /"  ${SQLFILE_CH0021_WRK_04}

cp -f ${SQLFILE_CH0041} ${SQLFILE_CH0041_WRK}

cp -f ${SQLFILE_CH0111} ${SQLFILE_CH0111_WRK}

cp -f ${DEFFILE} ${DEFFILE_WRK}
sed -i -e "s/\:OPE_DATE/\"${RSLT_OPEDATE}\"/"                 ${DEFFILE_WRK}
sed -i -e "s%\:CSVFILE_CH0111%${CSVFILE_CH0111}%"             ${DEFFILE_WRK}
sed -i -e "s%\:INFILE_CHIFM186001%${INFILE_CHIFM186001_WRK}%" ${DEFFILE_WRK}
sed -i -e "s%\:CSVFILE_CH0041%${CSVFILE_CH0041}%"             ${DEFFILE_WRK}
sed -i -e "s%\:CSVFILE_CH0401%${CSVFILE_CH0401}%"             ${DEFFILE_WRK}
sed -i -e "s%\:INFILE_CHIFM183002%${INFILE_CHIFM183002}%"     ${DEFFILE_WRK}

# OM-2015-0003141 性能改善 マッチング処理の一本化 2015/12/14 福山 MOD START
#cp -f  ${DEFFILE_WRK}  ${DEFFILE_WRK_01}
#cp -f  ${DEFFILE_WRK}  ${DEFFILE_WRK_02}
#cp -f  ${DEFFILE_WRK}  ${DEFFILE_WRK_03}
#cp -f  ${DEFFILE_WRK}  ${DEFFILE_WRK_04}
#sed -i -e "s%\:CSVFILE_CH0021%${CSVFILE_CH0021_WRK_01}%"      ${DEFFILE_WRK_01}
#sed -i -e "s%\:CSVFILE_CH0021%${CSVFILE_CH0021_WRK_02}%"      ${DEFFILE_WRK_02}
#sed -i -e "s%\:CSVFILE_CH0021%${CSVFILE_CH0021_WRK_03}%"      ${DEFFILE_WRK_03}
#sed -i -e "s%\:CSVFILE_CH0021%${CSVFILE_CH0021_WRK_04}%"      ${DEFFILE_WRK_04}
sed -i -e "s%\:CSVFILE_CH0021%${CSVFILE_CH0021_WRK_ALL}%"     ${DEFFILE_WRK}
# OM-2015-0003141 性能改善 マッチング処理の一本化  2015/12/14 福山 MOD END

#
#--- アンロードファイルのクリアを行う
#
cat /dev/null > $OUTFILE

#
#--- サブルーチン（UNLOAD）
#
UNLOAD(){

#unload
sh ${G_TOOLSH}/EOKULD03.sh $1 $2

rc=$?
if [ $rc -ne 0 ]
then
      sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " unload error($2:rc=$rc) "
      echo $JOBNAME " unload error($2:rc=$rc) "
      exit ${G_RTN_ERROR}
fi

}

#
#--- サブルーチン（CH_T_NYUKIN_SORT）
#

CH_T_NYUKIN_SORT(){

#SELECT NYUKIN_NO,NYUKIN_ROUTE_CD,NYUKIN_STAT,SEIKY_NO,SEIKY_KEI_NO
#FROM CH_T_NYUKIN 
#ORDER BY NYUKIN_NO
#ST4-2014-0000077 MOD STA
#bsortex -sort key="0.12asc" -record recform=txtcsv -input reclen=120 \
# include="5.1asc.eq.'0'.and.10.1asc.eq.'0'" \
# reconst="0.12,1.3,2.2,3.12,4.10,5.1,6.8,7.9,8.8,9.9,10.1" \
# < ${CSVFILE_CH0111_WRK} > ${CSVFILE_CH0111}
# OM-2015-0003141 性能改善 ソート削除対応 2015/12/14 福山 MOD START
#bsortex -sort key="0.12asc" -record recform=txtcsv -input reclen=120 \
# reconst="0.12,1.3,2.2,3.12,4.10,5.1,6.8,7.9,8.8,9.9,10.1" \
# < ${CSVFILE_CH0111_WRK} > ${CSVFILE_CH0111}
bsortex -copy -record recform=txtcsv -input reclen=120 \
 reconst="0.12,1.3,2.2,3.12,4.10,5.1,6.8,7.9,8.8,9.9,10.1" \
 < ${CSVFILE_CH0111_WRK} > ${CSVFILE_CH0111}
# OM-2015-0003141 性能改善 ソート削除対応 2015/12/14 福山 MOD END
#ST4-2014-0000077 MOD END

echo "sort CH_T_NYUKIN.csv"
}

#
#--- サブルーチン（CH_T_SAIKEN_SORT）
#
CH_T_SAIKEN_SORT(){

#SELECT SEIKY_KEI_NO,SAIKEN_NO,SAIKEN_STAT,SAIKEN_YM FROM CH_T_SAIKEN
#WHERE SAIKEN_STAT IN (020, 030, 040, 060, 080, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
#AND MK_FLG = '0' ORDER BY SEIKY_KEI_NO,SAIKEN_YM
bsortex -sort key="1.10asc,2.6asc" -record recform=txtcsv -input reclen=80 \
 include="3.3asc.eq.'020'.or.3.3asc.eq.'030'.or.3.3asc.eq.'040'.or.3.3asc.eq.'060'.or.3.3asc.eq.'080'.and.5.1asc.eq.'0'" \
 reconst="0.12,1.10,2.6,3.3,4.1,5.1" \
 < ${CSVFILE_CH0011_WRK} > ${CSVFILE_CH0011}

echo "sort CH_T_SAIKEN.csv"
}

#--- サブルーチン (MATCHING)マッチング処理
MATCHING(){
(export ZTLOUTFILE=$1
${G_TOOLSH}/util/bin/ZTLMAT01 $2)
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " Matching Error($SVC matching:rc=$rc) "
    echo $JOBNAME " Matching Error($SVC matching:rc=$rc) "
    exit ${G_RTN_ERROR}
fi
}

#
#--- MAIN
#
#--- 入力ファイル（請求アンロードファイル）
#--- 絞込みを行う
#IT2-2014-0000167・OM-2014-0001880 MOD STA
#(
#bsortex \
#  -copy \
#  -record recform=txtcsv \
#  -input reclen=150 \
#  file=${INFILE_CHIFM186001} \
#  -output file=${INFILE_CHIFM186001_WRK} \
#  reconst="0.12,1.12,2.6"
#)&
(
bsortex \
  -copy \
  -record recform=txtcsv \
  -input reclen=150 \
  file=${INFILE_CHIFM186001} \
  -output file=${INFILE_CHIFM186001_WRK} \
  reconst="0.12,1.12,2.6,9.1"
)&
#IT2-2014-0000167・OM-2014-0001880 MOD END
pid_SORT_CHIFM186=$!

#アンロード処理
# OM-2015-0003141 性能改善 並列実行数の見直し 2015/12/14 福山 MOD START
#UNLOAD ${SQLFILE_CH0021_WRK_01} ${CSVFILE_CH0021_WRK_01} &
#pid_UNLOAD_CH0021_01=$!
#UNLOAD ${SQLFILE_CH0021_WRK_02} ${CSVFILE_CH0021_WRK_02} &
#pid_UNLOAD_CH0021_02=$!
#UNLOAD ${SQLFILE_CH0021_WRK_03} ${CSVFILE_CH0021_WRK_03} &
#pid_UNLOAD_CH0021_03=$!
#UNLOAD ${SQLFILE_CH0021_WRK_04} ${CSVFILE_CH0021_WRK_04} &
#pid_UNLOAD_CH0021_04=$!
#UNLOAD ${SQLFILE_CH0111_WRK} ${CSVFILE_CH0111_WRK} &
#pid_UNLOAD_CH0111=$!
#UNLOAD ${SQLFILE_CH0401_WRK} ${CSVFILE_CH0401} &
#pid_UNLOAD_CH0401=$!
#UNLOAD ${SQLFILE_CH0041_WRK} ${CSVFILE_CH0041} &
#pid_UNLOAD_CH0041=$!
UNLOAD ${SQLFILE_CH0401_WRK} ${CSVFILE_CH0401}
UNLOAD ${SQLFILE_CH0111_WRK} ${CSVFILE_CH0111_WRK}

UNLOAD ${SQLFILE_CH0021_WRK_01} ${CSVFILE_CH0021_WRK_01} &
pid_UNLOAD_CH0021_01=$!
UNLOAD ${SQLFILE_CH0021_WRK_02} ${CSVFILE_CH0021_WRK_02} &
pid_UNLOAD_CH0021_02=$!
UNLOAD ${SQLFILE_CH0021_WRK_03} ${CSVFILE_CH0021_WRK_03} &
pid_UNLOAD_CH0021_03=$!
UNLOAD ${SQLFILE_CH0021_WRK_04} ${CSVFILE_CH0021_WRK_04} &
pid_UNLOAD_CH0021_04=$!

# OM-2015-0003141 性能改善 性能改善 並列実行数の見直し 2015/12/14 福山 MOD END
#- 処理結果判定
# OM-2015-0003141 性能改善 性能改善 並列実行数の見直し 2015/12/14 福山 MOD START
#wait ${pid_UNLOAD_CH0021_01}
#rc_UNLOAD_CH0021_01=$?
#wait ${pid_UNLOAD_CH0021_02}
#rc_UNLOAD_CH0021_02=$?
#wait ${pid_UNLOAD_CH0021_03}
#rc_UNLOAD_CH0021_03=$?
#wait ${pid_UNLOAD_CH0021_04}
#rc_UNLOAD_CH0021_04=$?
#wait ${pid_UNLOAD_CH0111}
#rc_UNLOAD_CH0111=$?
#wait ${pid_UNLOAD_CH0401}
#rc_UNLOAD_CH0401=$?
#wait ${pid_UNLOAD_CH004}
#rc_UNLOAD_CH0041=$?
wait ${pid_UNLOAD_CH0021_01}
rc_UNLOAD_CH0021_01=$?
if [ ${rc_UNLOAD_CH0021_01} -ne 0 ]
then
   sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0021_02:rc=${rc_UNLOAD_CH0021_01}) "
   echo $JOBNAME "UNLOAD ERROR(CH0021_02:rc=${rc_UNLOAD_CH0021_01}) "
   #- 異常終了
   exit ${G_RTN_ERROR}
fi
UNLOAD ${SQLFILE_CH0041_WRK} ${CSVFILE_CH0041} &
pid_UNLOAD_CH0041=$!
wait ${pid_UNLOAD_CH0041}
rc_UNLOAD_CH0041=$?
wait ${pid_UNLOAD_CH0021_02}
rc_UNLOAD_CH0021_02=$?
wait ${pid_UNLOAD_CH0021_03}
rc_UNLOAD_CH0021_03=$?
wait ${pid_UNLOAD_CH0021_04}
rc_UNLOAD_CH0021_04=$?
# OM-2015-0003141 性能改善 性能改善 並列実行数の見直し 2015/12/14 福山 MOD END
# OM-2015-0003141 性能改善 パラレル実行変更 2015/12/14 福山 MOD START
#if [ ${rc_UNLOAD_CH0021_01} -ne 0 ] || [ ${rc_UNLOAD_CH0021_02} -ne 0 ] || [ ${rc_UNLOAD_CH0021_03} -ne 0 ] || [ ${rc_UNLOAD_CH0021_04} -ne 0 ] || [ ${rc_UNLOAD_CH0111} -ne 0 ] || [ ${rc_UNLOAD_CH0401} -ne 0 ] || [ ${rc_UNLOAD_CH0041} -ne 0 ]
#then
#    #- エラーメッセージ出力
#    if [ ${rc_UNLOAD_CH0021_01} -ne 0 ]
#    then
#        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0021_01:rc=${rc_UNLOAD_CH0021_01}) "
#        echo $JOBNAME "UNLOAD ERROR(CH0021_01:rc=${rc_UNLOAD_CH0021_01}) "
#    fi
#    if [ ${rc_UNLOAD_CH0021_02} -ne 0 ]
#    then
#        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0021_02:rc=${rc_UNLOAD_CH0021_02}) "
#        echo $JOBNAME "UNLOAD ERROR(CH0021_02:rc=${rc_UNLOAD_CH0021_02}) "
#    fi
#    if [ ${rc_UNLOAD_CH0021_03} -ne 0 ]
#    then
#        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0021_03:rc=${rc_UNLOAD_CH0021_03}) "
#        echo $JOBNAME "UNLOAD ERROR(CH0021_03:rc=${rc_UNLOAD_CH0021_03}) "
#    fi
#    if [ ${rc_UNLOAD_CH0021_04} -ne 0 ]
#    then
#        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0021_04:rc=${rc_UNLOAD_CH0021_04}) "
#        echo $JOBNAME "UNLOAD ERROR(CH0021_04:rc=${rc_UNLOAD_CH0021_04}) "
#    fi
#    if [ ${rc_UNLOAD_CH0111} -ne 0 ]
#    then
#        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0111:rc=${rc_UNLOAD_CH0111}) "
#        echo $JOBNAME "UNLOAD ERROR(CH0111:rc=${rc_UNLOAD_CH0111}) "
#    fi
#    if [ ${rc_UNLOAD_CH0401} -ne 0 ]
#    then
#        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0401:rc=${rc_UNLOAD_CH0401}) "
#        echo $JOBNAME "UNLOAD ERROR(CH0401:rc=${rc_UNLOAD_CH0401}) "
#    fi
#    if [ ${rc_UNLOAD_CH0041} -ne 0 ]
#    then
#        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0041:rc=${rc_UNLOAD_CH0041}) "
#        echo $JOBNAME "UNLOAD ERROR(CH0041:rc=${rc_UNLOAD_CH0041}) "
#    fi
#    #- 異常終了
#    exit ${G_RTN_ERROR}
#fi
if [ ${rc_UNLOAD_CH0041} -ne 0 ] || [ ${rc_UNLOAD_CH0021_02} -ne 0 ] || [ ${rc_UNLOAD_CH0021_03} -ne 0 ] || [ ${rc_UNLOAD_CH0021_04} -ne 0 ]
then
    #- エラーメッセージ出力

    if [ ${rc_UNLOAD_CH0041} -ne 0 ]
    then
        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0041:rc=${rc_UNLOAD_CH0041}) "
        echo $JOBNAME "UNLOAD ERROR(CH0041:rc=${rc_UNLOAD_CH0041}) "
    fi
    if [ ${rc_UNLOAD_CH0021_02} -ne 0 ]
    then
        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0021_02:rc=${rc_UNLOAD_CH0021_02}) "
        echo $JOBNAME "UNLOAD ERROR(CH0021_02:rc=${rc_UNLOAD_CH0021_02}) "
    fi
    if [ ${rc_UNLOAD_CH0021_03} -ne 0 ]
    then
        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0021_03:rc=${rc_UNLOAD_CH0021_03}) "
        echo $JOBNAME "UNLOAD ERROR(CH0021_03:rc=${rc_UNLOAD_CH0021_03}) "
    fi
    if [ ${rc_UNLOAD_CH0021_04} -ne 0 ]
    then
        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0021_04:rc=${rc_UNLOAD_CH0021_04}) "
        echo $JOBNAME "UNLOAD ERROR(CH0021_04:rc=${rc_UNLOAD_CH0021_04}) "
    fi
    #- 異常終了
    exit ${G_RTN_ERROR}
fi

# OM-2015-0003141 性能改善 並列実行数の見直し 2015/12/14 福山 MOD END

CH_T_NYUKIN_SORT

# マッチング処理
# OM-2015-0003141 性能改善 マッチング処理の一本化 2015/12/14 福山 MOD START
#MATCHING ${OUTFILE_WRK_01} ${DEFFILE_WRK_01} &
#pid_MATCHING_01=$!
#MATCHING ${OUTFILE_WRK_02} ${DEFFILE_WRK_02} &
#pid_MATCHING_02=$!
#MATCHING ${OUTFILE_WRK_03} ${DEFFILE_WRK_03} &
#pid_MATCHING_03=$!
#MATCHING ${OUTFILE_WRK_04} ${DEFFILE_WRK_04} &
#pid_MATCHING_04=$!
#
#wait ${pid_MATCHING_01}
#rc_MATCHING_01=$?
#wait ${pid_MATCHING_02}
#rc_MATCHING_02=$?
#wait ${pid_MATCHING_03}
#rc_MATCHING_03=$?
#wait ${pid_MATCHING_04}
#rc_MATCHING_04=$?
cat ${CSVFILE_CH0021_WRK_01} > ${CSVFILE_CH0021_WRK_ALL}
cat ${CSVFILE_CH0021_WRK_02} >> ${CSVFILE_CH0021_WRK_ALL}
cat ${CSVFILE_CH0021_WRK_03} >> ${CSVFILE_CH0021_WRK_ALL}
cat ${CSVFILE_CH0021_WRK_04} >> ${CSVFILE_CH0021_WRK_ALL}
MATCHING ${OUTFILE_WRK_ALL} ${DEFFILE_WRK} &
pid_MATCHING=$!
wait ${pid_MATCHING}
rc_MATCHING=$?
# OM-2015-0003141 性能改善 パマッチング処理の一本化 2015/12/14 福山 MOD END

#- 処理結果判定
# OM-2015-0003141 性能改善 マッチング処理の一本化 2015/12/14 福山 MOD START
#if [ ${rc_MATCHING_01} -ne 0 ] || [ ${rc_MATCHING_02} -ne 0 ] || [ ${rc_MATCHING_03} -ne 0 ] || [ ${rc_MATCHING_04} -ne 0 ]
#then
#    #- エラーメッセージ出力
#    if [ ${rc_MATCHING_01} -ne 0 ]
#    then
#        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(MATCHING_01:rc=${rc_MATCHING_01}) "
#        echo $JOBNAME "UNLOAD ERROR(MATCHING_01:rc=${rc_MATCHING_01}) "
#    fi
#    if [ ${rc_MATCHING_02} -ne 0 ]
#    then
#        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0021_01_12:rc=${rc_MATCHING_02}) "
#        echo $JOBNAME "UNLOAD ERROR(CH0021_01_12:rc=${rc_MATCHING_02}) "
#    fi
#    if [ ${rc_MATCHING_03} -ne 0 ]
#    then
#        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0021_01_12:rc=${rc_MATCHING_03}) "
#        echo $JOBNAME "UNLOAD ERROR(CH0021_01_12:rc=${rc_MATCHING_03}) "
#    fi
#    if [ ${rc_MATCHING_04} -ne 0 ]
#    then
#        sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(CH0021_01_12:rc=${rc_MATCHING_04}) "
#        echo $JOBNAME "UNLOAD ERROR(CH0021_01_12:rc=${rc_MATCHING_04}) "
#    fi
if [ ${rc_MATCHING} -ne 0 ]
then
    #- エラーメッセージ出力
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD ERROR(MATCHING_01:rc=${rc_MATCHING}) "
    echo $JOBNAME "UNLOAD ERROR(MATCHING_01:rc=${rc_MATCHING}) "
# OM-2015-0003141 性能改善 マッチング処理の一本化 2015/12/14 福山 MOD START
    #- 異常終了
    exit ${G_RTN_ERROR}
fi

## 分割ファイル結合 
## ソート（請求契約番号、入金番号、債権年月）
#--- 改行コードをwindows (CRLF)に変換する
# OM-2015-0003141 性能改善 ソート削除対応 2015/12/14 福山 MOD START
#bsortex \
#  -sort   key="0.10asc,12.12asc,2.6asc" \
#  -record recform=txtcsv \
#  -input  file=${OUTFILE_WRK_01},${OUTFILE_WRK_02},${OUTFILE_WRK_03},${OUTFILE_WRK_04} \
#          reclen=300 \
#  -output file=${OUTFILE} \
#          linedlmt=crlf ;
bsortex \
  -sort   key="0.10asc,12.12asc,2.6asc" \
  -record recform=txtcsv \
  -input  file=${OUTFILE_WRK_ALL} \
          reclen=300 \
  -output file=${OUTFILE} \
          linedlmt=crlf ;
# OM-2015-0003141 性能改善 ソート削除対応 2015/12/14 福山 MOD END
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " bsortex Error($SVC bsortex:rc=$rc) "
    echo $JOBNAME " bsortex Error($SVC bsortex:rc=$rc) "
    exit ${G_RTN_ERROR}
fi
#
#---ＡＰＬ起動
#

#共通javaVMオプション指定(ヒープサイズ4096M)
java ${JAVA_OPTION_4096} -jar ${JAR_DIR}/koptBatch.jar $PARA &
pid_java=$!

#############################
#
#-- 領収登録用入金債権情報作成
#

DEFFILE3=${G_TOOLSH}/util/def/CH_CM_0020.def
DEFFILE3_WRK=${G_TOOLSH}/util/def/${JOBNAME}_CH_CM_0020_MATCHING_WK_1$TAJUKIDO.def
OUTFILE2=${MID_DIR_CH}/CHIFM165001.csv
OUTFILE2_WRK=${MID_DIR_CH}/${JOBNAME}_CHIFM165001_UNLOADER_WK_1$TAJUKIDO.csv

cp -f ${DEFFILE3} ${DEFFILE3_WRK}
sed -i -e "s/\:OPE_DATE/\"${RSLT_OPEDATE}\"/"                  ${DEFFILE3_WRK}
sed -i -e "s%\:CSVFILE_CH0111%${CSVFILE_CH0111}%"              ${DEFFILE3_WRK}
sed -i -e "s%\:INFILE_CHIFM186001%${INFILE_CHIFM186001_WRK}%"  ${DEFFILE3_WRK}
sed -i -e "s%\:CSVFILE_CH0041%${CSVFILE_CH0041}%"              ${DEFFILE3_WRK}
#IT2-2014-0000167・OM-2014-0001880 MOD STA
#sed -i -e "s%\:CSVFILE_CH0021%${CSVFILE_CH0021_WRK}%"          ${DEFFILE3_WRK}
sed -i -e "s%\:CSVFILE_CH0021_AMT%${CSVFILE_CH0021_WRK}%"      ${DEFFILE3_WRK}
sed -i -e "s%\:CSVFILE_CH0021_STX%${CSVFILE_CH0021_WRK_STX}%"  ${DEFFILE3_WRK}
#IT2-2014-0000167・OM-2014-0001880 MOD END

#IT2-2014-0000167・OM-2014-0001880 MOD STA
##--- 集約・ソートを行う
#bsortex \
#  -sort key="0.12asc" \
#  -record recform=txtcsv \
#  -input reclen=200 \
#  file=${CSVFILE_CH0021_WRK_01},${CSVFILE_CH0021_WRK_02},${CSVFILE_CH0021_WRK_03},${CSVFILE_CH0021_WRK_04} \
#  -summary suppress first \
#  -output file=${CSVFILE_CH0021_WRK}
#rc=$?
#if [ $rc -ne 0 ]
#then
#    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " sort Error($SVC sort:rc=$rc) "
#    echo $JOBNAME " sort Error($SVC sort:rc=$rc) "
#    exit ${G_RTN_ERROR}
#fi

#--- 債権額の抽出・ソートを行う
# 業務機能識別コード='SAIK_AMNT'
# OM-2015-0003141 性能改善 ソート削除対応 2015/12/14 福山 MOD START
#bsortex \
#  -sort key="0.12asc" \
#  -record recform=txtcsv \
#  -input reclen=300 \
#  file=${CSVFILE_CH0021_WRK_01},${CSVFILE_CH0021_WRK_02},${CSVFILE_CH0021_WRK_03},${CSVFILE_CH0021_WRK_04} \
#  include="11.9asc.eq.'SAIK_AMNT'" \
#  -output file=${CSVFILE_CH0021_WRK}
bsortex \
  -copy \
  -record recform=txtcsv \
  -input reclen=300 \
  file=${CSVFILE_CH0021_WRK_ALL} \
  include="11.9asc.eq.'SAIK_AMNT'" \
  -output file=${CSVFILE_CH0021_WRK}
# OM-2015-0003141 性能改善 ソート削除対応 2015/12/14 福山 MOD END
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " sort Error($SVC sort:rc=$rc) "
    echo $JOBNAME " sort Error($SVC sort:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#--- 債権額うち消費税の抽出・ソートを行う
# 業務機能識別コード='SAIKE_STX'
# OM-2015-0003141 性能改善 マッチング処理の一本化 2015/12/14 福山 MOD START
#bsortex \
#  -copy \
#  -record recform=txtcsv \
#  -input reclen=300 \
#  file=${CSVFILE_CH0021_WRK_01},${CSVFILE_CH0021_WRK_02},${CSVFILE_CH0021_WRK_03},${CSVFILE_CH0021_WRK_04} \
#  include="11.9asc.eq.'SAIKE_STX'" \
#  -output file=${CSVFILE_CH0021_WRK_STX_01}
bsortex \
  -copy \
  -record recform=txtcsv \
  -input reclen=300 \
  file=${CSVFILE_CH0021_WRK_ALL} \
  include="11.9asc.eq.'SAIKE_STX'" \
  -output file=${CSVFILE_CH0021_WRK_STX_01}
# OM-2015-0003141 性能改善 マッチング処理の一本化 2015/12/14 福山 MOD END
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " sort Error($SVC sort:rc=$rc) "
    echo $JOBNAME " sort Error($SVC sort:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#--- 集約・ソートを行う
bsort -s -z300 -Tflt -t, -0.12asc -g5.12ascd -o ${CSVFILE_CH0021_WRK_STX} ${CSVFILE_CH0021_WRK_STX_01}
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " sort Error($SVC sort:rc=$rc) "
    echo $JOBNAME " sort Error($SVC sort:rc=$rc) "
    exit ${G_RTN_ERROR}
fi
#IT2-2014-0000167・OM-2014-0001880 MOD END

# マッチング処理→入力ファイルへ
(export ZTLOUTFILE=${OUTFILE2_WRK}
${G_TOOLSH}/util/bin/ZTLMAT01 ${DEFFILE3_WRK})
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " Matching Error($SVC matching:rc=$rc) "
    echo $JOBNAME " Matching Error($SVC matching:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#IT2-2014-0000167・OM-2014-0001880 ADD STA
#bsort -s -z100 -Tflt -t, -1.12asca,2.12asca -o ${OUTFILE2} ${OUTFILE2_WRK}
bsort -s -z200 -Tflt -t, -1.12asca,2.12asca -o ${OUTFILE2} ${OUTFILE2_WRK}
#IT2-2014-0000167・OM-2014-0001880 ADD END
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " SORT Error($SVC sort:rc=$rc) "
    echo $JOBNAME " SORT Error($SVC sort:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

# javaの処理結果判定
wait ${pid_java}
rc=$?
ERR_FLG=0
if [ $rc -ne 0 ]
then
   if [ $rc -ne 4 ]
   then
       if [ $rc -ne 8 ]
       then
           if [ $rc -ne 127 ]
           then
              sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " PROGRAM Error($SVC program:rc=$rc) "
              echo $JOBNAME " PROGRAM Error($SVC program:rc=$rc) "
              exit ${G_RTN_ERROR}
           fi
       fi
    fi
    ERR_FLG=1
fi

exit_rc=$rc

#ワーク削除
if [ $WK_RM = "true" ]
then
    rm -f ${INFILE_CHIFM186001_WRK}
    rm -f ${DEFFILE3_WRK}
    rm -f ${DEFFILE_WRK}
    rm -f ${SQLFILE_CH0401_WRK}
    rm -f ${SQLFILE_CH0021_WRK}
    rm -f ${SQLFILE_CH0041_WRK}
    rm -f ${SQLFILE_CH0111_WRK}
    rm -f ${OUTFILE2_WRK}
    rm -f ${CSVFILE_CH0401}
    rm -f ${CSVFILE_CH0401_WRK}
    rm -f ${CSVFILE_CH0021}
    rm -f ${CSVFILE_CH0021_WRK}
    rm -f ${CSVFILE_CH0041}
    rm -f ${CSVFILE_CH0111}
    rm -f ${CSVFILE_CH0111_WRK}
    rm -f ${SQLFILE_CH0021_WRK_01}
    rm -f ${SQLFILE_CH0021_WRK_02}
    rm -f ${SQLFILE_CH0021_WRK_03}
    rm -f ${SQLFILE_CH0021_WRK_04}
# OM-2015-0003141 性能改善 マッチング処理の一本化 2015/12/14 福山 DEL START
#    rm -f ${OUTFILE_WRK_01}
#    rm -f ${OUTFILE_WRK_02}
#    rm -f ${OUTFILE_WRK_03}
#    rm -f ${OUTFILE_WRK_04}
# OM-2015-0003141 性能改善 マッチング処理の一本化 2015/12/14 福山 DEL END
    rm -f ${CSVFILE_CH0021_WRK_01}
    rm -f ${CSVFILE_CH0021_WRK_02}
    rm -f ${CSVFILE_CH0021_WRK_03}
    rm -f ${CSVFILE_CH0021_WRK_04}
# OM-2015-0003141 性能改善 マッチング処理の一本化 2015/12/14 福山 DEL START
#    rm -f ${DEFFILE_WRK_01}
#    rm -f ${DEFFILE_WRK_02}
#    rm -f ${DEFFILE_WRK_03}
#    rm -f ${DEFFILE_WRK_04}
# OM-2015-0003141 性能改善 マッチング処理の一本化 2015/12/14 福山 DEL END
# OM-2015-0003141 性能改善 マッチング処理の一本化 2015/12/14 福山 ADD START
     rm -f ${OUTFILE_WRK_ALL}
     rm -f ${CSVFILE_CH0021_WRK_ALL}
# OM-2015-0003141 性能改善 マッチング処理の一本化 2015/12/14 福山 ADD END
#IT2-2014-0000167・OM-2014-0001880 ADD STA
    rm -f ${CSVFILE_CH0021_WRK_STX}
    rm -f ${CSVFILE_CH0021_WRK_STX_01}
#IT2-2014-0000167・OM-2014-0001880 ADD STA
fi
#############################

#
#--- ジョブの終了メッセージを出力する
#
sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME

exit $exit_rc