#!/bin/bash
##############################################################
# システム名    ：eo顧客基幹システム
#
# サブシステム名：契約管理
#
# シェル名      ：スキーマ抽出ファイルマッチング
#
# 機能          ：各スキーマから抽出した必要なデータをマッチングする。
#
# コマンド形式  ：EO2DU0144J0.sh
#
# 実行環境      ：.../app/shl
#
# 終了ステータス：ゼロ以外異常
#
# 特記事項      ：特になし
#
# 変更履歴      ：変更日      変更者       障害／仕様変更No.
# v10.00.00       2014/08/12  FJ)米田      【ANK-2090-00-00】以下の項目の設定を行うように修正
#                                                            ・電話番号
#                                                            ・リモートサポートプラス加入有無
#                                                            ・メールアドレス件数
#                                                            ・ウィルスチェック件数
#                                                            ・ウィルスバスター有無
#                                                            ・有害Webフィルター有無
#                                                            ・ファミリーパック申込有無
#                                                            ・プレミアムオプション申込有無
# v29.00.00       2016/10/03  FJ)柳        【ANK-2990-00-00】【eo電気】同時申込・量販訪販対応（STEP2-2）
# v29.01.00       2017/02/20  FJ)柳        【IT1-2017-0000007】FOCS参照用サービス契約ワークレコード登録不正対応
# v32.00.00       2017/04/03  FJ)澤田      【ANK-3149-00-00】新セキュリティパック導入
# v32.01.00       2017/04/28  FJ)大崎      【ANK-3149-09-00】新セキュリティパック導入　FOCS連携項目変更
# v37.00.00       2018/05/10  FJ)中原      【ANK-3366-01-00】eo光設備卸対応（FOCS向けVIEWに卸契約を識別できる情報を追加）
# v37.01.00       2018/05/30  FJ)柳        【ANK-3366-16-00】eo光設備卸対応（FOCS向けVIEWの卸先事業者名について、半角変換が可能な文字は半角変換して返却）
# v44.00.00       2019/05/31  FJ)前田      【ANK-3653-00-00】台風21号対策（FOCS参照用サービス契約ワーク改修）対応
# v56.00.00       2021/09/30  FJ)吉村      【ANK-4038-00-00】【eo定期】光ローゼット化対応
# v56.00.01       2021/11/04  FJ)吉村      【ANK-4038-05-00】【eo定期】光ローゼット化対応(連携桁数変更対応)
# v60.00.00       2022/08/08  FJ)原        【ANK-4269-00-00】マンション卸回線(WI-FIスキーム)の不備対応　STEP2
# v60.00.01       2022/09/06  FJ)藤本涼    【ANK-4244-14-00】【eo定期】MT既設賃貸対応
# v65.00.00       2023/02/13  FJ)小竹      【ANK-4346-00-00】【eo定期】CCMG再構築対応
##############################################################

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

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

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

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

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

#
#---OPD
#
OPD=$1

#
#---業務で必要な変数定義
#
#xxx=xxxxxxx
##############################################################
# 業務処理
##############################################################
sh ${G_TOOLSH}/EOK010210J0.sh CS00025I $JOBNAME

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

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

P1="OPD=,"
# ANK-3366-16-00 2018/05/30 MOD START
#P2="SVCCTL=,"
P2="SVCCTL=JBSbatMultiServiceControl,"
# ANK-3366-16-00 2018/05/30 MOD END
P3="JOB=EO2DU0144J0,"
# ANK-3366-16-00 2018/05/30 MOD START
#P4="IND1=,"
#P5="INF1=,"
P4="IND1=CCIFM047.def,"
P5="INF1=${LOC_DIR_CC}/CCIFM047001_crnt.csv,"
# ANK-3366-16-00 2018/05/30 MOD END
P6="IND2=,"
P7="INF2=,"
# ANK-3366-16-00 2018/05/30 MOD START
#P8="OTD1=,"
#P9="OTF1=,"
P8="OTD1=CCIFM047.def,"
P9="OTF1=${LOC_DIR_CC}/CCIFM047001_hankaku.csv,"
# ANK-3366-16-00 2018/05/30 MOD END
P10="OTD2=,"
P11="OTF2=,"
P12="TABLENAME=,"
P13="SQLKEY=,"
P14="SQLPARAM=,"
P15="ERRFILE=,"
P16="RECOVERY=,"
P17="BREAKPTN=,"
# ANK-4269-00-00 2022/08/08 MOD START
#P18="FREE="
P18="FREE=${MID_DIR_KK}/KKIFM335001_crnt.csv;${MID_DIR_KK}/KKIFM335001_hankaku.csv"
# ANK-4269-00-00 2022/08/08 MOD END
PARA="$P1$P2$P3$P4$P5$P6$P7$P8$P9$P10$P11$P12$P13$P14$P15$P16$P17$P18"

#
#--- ファイル定義
#
DEFFILE1=${G_TOOLSH}/util/def/KK_CM_0039.def
TMPDEFFILE1=${ULD_WORK_DIR}/KK_CM_0039.tmp.${JOBNAME}.def
OUTFILE=${MID_DIR_KK}/KKIFM393001.csv

DEFFILE2=${G_TOOLSH}/util/def/KK_CM_0040.def
TMPDEFFILE2=${ULD_WORK_DIR}/KK_CM_0040.tmp.${JOBNAME}.def
OUTFILE2=${MID_DIR_KK}/KKIFM394001.csv

DEFFILE3=${G_TOOLSH}/util/def/KK_CM_0041.def
TMPDEFFILE3=${ULD_WORK_DIR}/KK_CM_0041.tmp.${JOBNAME}.def
OUTFILE3=${MID_DIR_KK}/KKIFM395001.csv

DEFFILE4=${G_TOOLSH}/util/def/KK_CM_0042.def
TMPDEFFILE4=${ULD_WORK_DIR}/KK_CM_0042.tmp.${JOBNAME}.def
OUTFILE4=${MID_DIR_KK}/KKIFM399001.csv

DEFFILE5=${G_TOOLSH}/util/def/KK_CM_0043.def
TMPDEFFILE5=${ULD_WORK_DIR}/KK_CM_0043.tmp.${JOBNAME}.def
OUTFILE5=${MID_DIR_KK}/KKIFM401001.csv

DEFFILE6=${G_TOOLSH}/util/def/KK_CM_0044.def
TMPDEFFILE6=${ULD_WORK_DIR}/KK_CM_0044.tmp.${JOBNAME}.def
OUTFILE6=${MID_DIR_KK}/KKIFM402001.csv

#--- v10.00.00 2014/08/12 ADD START
DEFFILE7=${G_TOOLSH}/util/def/KK_CM_0514.def
TMPDEFFILE7=${ULD_WORK_DIR}/KK_CM_0514.tmp.${JOBNAME}.def
OUTFILE7=${MID_DIR_KK}/KKIFM623002.csv

DEFFILE8=${G_TOOLSH}/util/def/KK_CM_0515.def
TMPDEFFILE8=${ULD_WORK_DIR}/KK_CM_0515.tmp.${JOBNAME}.def
OUTFILE8=${MID_DIR_KK}/KKIFM624002_b001.csv

DEFFILE9=${G_TOOLSH}/util/def/KK_CM_0516.def
TMPDEFFILE9=${ULD_WORK_DIR}/KK_CM_0516.tmp.${JOBNAME}.def
OUTFILE9=${MID_DIR_KK}/KKIFM624002_b021.csv

DEFFILE10=${G_TOOLSH}/util/def/KK_CM_0517.def
TMPDEFFILE10=${ULD_WORK_DIR}/KK_CM_0517.tmp.${JOBNAME}.def
OUTFILE10=${MID_DIR_KK}/KKIFM624002_b077.csv

# ANK-4346-00-00 2023/02/13 DEL START
#DEFFILE11=${G_TOOLSH}/util/def/KK_CM_0518.def
#TMPDEFFILE11=${ULD_WORK_DIR}/KK_CM_0518.tmp.${JOBNAME}.def
#OUTFILE11=${MID_DIR_KK}/KKIFM626002_virus.csv
#
#DEFFILE12=${G_TOOLSH}/util/def/KK_CM_0519.def
#TMPDEFFILE12=${ULD_WORK_DIR}/KK_CM_0519.tmp.${JOBNAME}.def
#OUTFILE12=${MID_DIR_KK}/KKIFM626002_web.csv
# ANK-4346-00-00 2023/02/13 DEL END

DEFFILE13=${G_TOOLSH}/util/def/KK_CM_0523.def
TMPDEFFILE13=${ULD_WORK_DIR}/KK_CM_0523.tmp.${JOBNAME}.def
OUTFILE13=${MID_DIR_KK}/KKIFM625002.csv

DEFFILE14=${G_TOOLSH}/util/def/KK_CM_0524.def
TMPDEFFILE14=${ULD_WORK_DIR}/KK_CM_0524.tmp.${JOBNAME}.def
OUTFILE14=${MID_DIR_KK}/KKIFM379002_other.csv
#--- v10.00.00 2014/08/12 ADD END
# ANK-2990-00-00 2016/10/03 ADD START
# マッチングツール定義ファイル
# (マッチングファイル（回線対象サービス契約）カレント－同一場所ｅｏ電気契約マージファイル)
MATCHDEF_KK0241=${G_TOOLSH}/util/def/KK_CM_0604.def
# 同一場所ｅｏ電気契約抽出ファイル
TMPFILE_KKIFM718=${LOC_DIR_KK}/KKIFM718001.csv
# ANK-2990-00-00 2016/10/03 ADD END
# IT1-2017-0000007 2017/02/20 ADD START
# 同一場所ｅｏ電気契約抽出カレントファイル
TMPFILE_KKIFM718_CRNT=${LOC_DIR_KK}/KKIFM718001_crnt.csv
# IT1-2017-0000007 2017/02/20 ADD END

# ANK-3149-00-00 2017/04/03 ADD START
#セキュリティ情報抽出
DEFFILE15=${G_TOOLSH}/util/def/KK_CM_0613.def
TMPDEFFILE15=${ULD_WORK_DIR}/KK_CM_0613.tmp.${JOBNAME}.def
OUTFILE15=${MID_DIR_KK}/KKIFM728002.csv

#インターネットサギウォール情報抽出
DEFFILE16=${G_TOOLSH}/util/def/KK_CM_0614.def
TMPDEFFILE16=${ULD_WORK_DIR}/KK_CM_0614.tmp.${JOBNAME}.def
OUTFILE16=${MID_DIR_KK}/KKIFM624002_b131.csv

#ノートンファミリープレミア情報抽出
DEFFILE17=${G_TOOLSH}/util/def/KK_CM_0615.def
TMPDEFFILE17=${ULD_WORK_DIR}/KK_CM_0615.tmp.${JOBNAME}.def
OUTFILE17=${MID_DIR_KK}/KKIFM624002_b132.csv

# ANK-3149-00-00 2017/04/03 ADD END
# ANK-3149-09-00 2017/04/28 ADD START
#セキュリティオプション有情報抽出
DEFFILE18=${G_TOOLSH}/util/def/KK_CM_0616.def
TMPDEFFILE18=${ULD_WORK_DIR}/KK_CM_0616.tmp.${JOBNAME}.def
OUTFILE18=${MID_DIR_KK}/KKIFM624003_b131b132.csv

#セキュリティオプション無情報抽出
DEFFILE19=${G_TOOLSH}/util/def/KK_CM_0617.def
TMPDEFFILE19=${ULD_WORK_DIR}/KK_CM_0617.tmp.${JOBNAME}.def
OUTFILE19=${MID_DIR_KK}/KKIFM624004_b131b132.csv

#オプションサービス名称抽出
SQLFILE=${SQL_DIR}/KK_U_KK0821_03.sql
OUTFILE20=${MID_DIR_KK}/KKIFM731001.csv

# ANK-3366-01-00 2018/05/10 ADD START
# 卸先事業者マスタ全件
TMPFILE_CCIFM046=${MID_DIR_CC}/CCIFM046001.csv
# 卸先事業者マスタソート
TMPFILE_CCIFM047_SORT=${LOC_DIR_CC}/CCIFM047001_sort.csv
# 卸先事業者マスタカレント
TMPFILE_CCIFM047_CRNT=${LOC_DIR_CC}/CCIFM047001_crnt.csv
# ANK-3366-01-00 2018/05/10 ADD END
# ANK-3653-00-00 2019/06/04 ADD START

#工事案件番号マッチング
DEFFILE21=${G_TOOLSH}/util/def/KK_CM_0689.def
TMPDEFFILE21=${ULD_WORK_DIR}/KK_CM_0689.tmp.${JOBNAME}.def
OUTFILE21=${MID_DIR_KK}/KKIFM878003.csv

#認証IDマッチング
DEFFILE22=${G_TOOLSH}/util/def/KK_CM_0690.def
TMPDEFFILE22=${ULD_WORK_DIR}/KK_CM_0690.tmp.${JOBNAME}.def
OUTFILE22=${MID_DIR_KK}/KKIFM878004.csv

#TV関連工事案件番号情報マッチング
DEFFILE23=${G_TOOLSH}/util/def/KK_CM_0691.def
TMPDEFFILE23=${ULD_WORK_DIR}/KK_CM_0691.tmp.${JOBNAME}.def
OUTFILE23=${MID_DIR_KK}/KKIFM878005.csv

#TV関連認証ID情報マッチング
DEFFILE24=${G_TOOLSH}/util/def/KK_CM_0692.def
TMPDEFFILE24=${ULD_WORK_DIR}/KK_CM_0692.tmp.${JOBNAME}.def
OUTFILE24=${MID_DIR_KK}/KKIFM878006.csv

# ANK-4038-00-00 2021/09/30 ADD START
# 業務パラメータ取得ファイル
ZM0321_OUTFILE=${MID_DIR_KK}/${JOBNAME}.ZM0321_OUT.csv
# カラム登録外含む全件取得ファイル
OUTFILE25_TMP=${LOC_DIR_KK}/KKIFM401001_work_TMP.csv
# マンション光コンセント（１Ｇ）ソートファイル
OUTFILE26=${MID_DIR_KK}/KKIFM401001_1.csv
# マンション光コンセント（５Ｇ）ソートファイル
OUTFILE27=${MID_DIR_KK}/KKIFM401001_2.csv
# マンション光コンセント（１０Ｇ）ソートファイル
OUTFILE28=${MID_DIR_KK}/KKIFM401001_3.csv
# マンション光コンセント以外のソートファイル
OUTFILE29=${MID_DIR_KK}/KKIFM401001_0.csv
# マンション光コンセント以外のソートファイル
OUTFILE30=${MID_DIR_KK}/KKIFM401001_crnt.csv
# ANK-4038-00-00 2021/09/30 ADD END
# ANK-4269-00-00 2022/08/09 ADD START
# カラム登録外含む全件取得ファイル（スキーム事業者名編集前）
OUTFILE26_TMP=${LOC_DIR_KK}/KKIFM401001_work_TMP2.csv
# スキーム事業者名のソートファイル
OUTFILE31=${MID_DIR_KK}/KKIFM401001_4.csv
# 卸事業者名のソートファイル
OUTFILE32=${MID_DIR_KK}/KKIFM401001_5.csv
# ANK-4269-00-00 2022/08/09 ADD END
# ANK-4244-14-00 2022/09/09 ADD START
# 光化マンション、既設賃貸マンション（１Ｇ）ソートファイル
OUTFILE33=${MID_DIR_KK}/KKIFM401001_6.csv
# 光化マンション、既設賃貸マンション（５Ｇ）ソートファイル
OUTFILE34=${MID_DIR_KK}/KKIFM401001_7.csv
# 光化マンション、既設賃貸マンション（１０Ｇ）ソートファイル
OUTFILE35=${MID_DIR_KK}/KKIFM401001_8.csv
# ANK-4244-14-00 2022/09/09 ADD END

# ANK-3653-00-00 2019/06/04 ADD END
#
#--- 各ファイルの存在チェックを行う
#
if [ ! -r $SQLFILE ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE) "
    echo $JOBNAME " File is nonexist($SQLFILE) "
    exit ${G_RTN_ERROR}
fi

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

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

#
#--- UNLOAD処理
#
sh ${G_TOOLSH}/EOKULD02.sh ${SQLFILE} ${OUTFILE20}

# ANK-3149-09-00 2017/04/28 ADD END

#
#--- 定義ファイル環境変数設定処理
#
cat ${DEFFILE1} > ${TMPDEFFILE1}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE1}

cat ${DEFFILE2} > ${TMPDEFFILE2}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE2}

cat ${DEFFILE3} > ${TMPDEFFILE3}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE3}

cat ${DEFFILE4} > ${TMPDEFFILE4}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE4}

cat ${DEFFILE5} > ${TMPDEFFILE5}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE5}
# ANK-3366-01-00 2018/05/10 ADD START
sed -i -e s@'${LOC_DIR_CC}'@${LOC_DIR_CC}@g ${TMPDEFFILE5}
# ANK-3366-01-00 2018/05/10 ADD END

cat ${DEFFILE6} > ${TMPDEFFILE6}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE6}

#--- v10.00.00 2014/08/12 ADD START
cat ${DEFFILE7} > ${TMPDEFFILE7}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE7}

cat ${DEFFILE8} > ${TMPDEFFILE8}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE8}

cat ${DEFFILE9} > ${TMPDEFFILE9}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE9}

cat ${DEFFILE10} > ${TMPDEFFILE10}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE10}

# ANK-4346-00-00 2023/02/13 DEL START
#cat ${DEFFILE11} > ${TMPDEFFILE11}
#sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE11}
#
#cat ${DEFFILE12} > ${TMPDEFFILE12}
#sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE12}
# ANK-4346-00-00 2023/02/13 DEL END

cat ${DEFFILE13} > ${TMPDEFFILE13}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE13}

cat ${DEFFILE14} > ${TMPDEFFILE14}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE14}
#--- v10.00.00 2014/08/12 ADD END

# ANK-3149-00-00 2017/04/03 ADD START
cat ${DEFFILE15} > ${TMPDEFFILE15}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE15}

cat ${DEFFILE16} > ${TMPDEFFILE16}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE16}

cat ${DEFFILE17} > ${TMPDEFFILE17}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE17}

# ANK-3149-00-00 2017/04/03 ADD END
# ANK-3149-09-00 2017/04/28 ADD START
cat ${DEFFILE18} > ${TMPDEFFILE18}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE18}

cat ${DEFFILE19} > ${TMPDEFFILE19}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE19}

# ANK-3149-09-00 2017/04/28 ADD END

# ANK-3653-00-00 2019/06/04 ADD START
cat ${DEFFILE21} > ${TMPDEFFILE21}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE21}

cat ${DEFFILE22} > ${TMPDEFFILE22}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE22}

cat ${DEFFILE23} > ${TMPDEFFILE23}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE23}

cat ${DEFFILE24} > ${TMPDEFFILE24}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE24}

# ANK-3653-00-00 2019/06/04 ADD END

# ANK-4038-00-00 2021/09/30 ADD START
# 各種アンロードクエリファイル
ZM0321_ULD_QUERY=${SQL_DIR}/KK_U_ZM0321_02.sql

#--- クエリ編集
#       p1：ＳＱＬ定義ファイル名
#       p2：バインド変数置換文字
EDIT_ULD_QUERY()
{
	SQL_FILE=$1
	SQL_WORK_FILE=${ULD_WORK_DIR}/${JOBNAME}_QUERY.tmp
	cat /dev/null > ${SQL_WORK_FILE}
	
	# SQL定義ファイルの編集
	if [ ! -r ${SQL_FILE} ]
	then
		sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist(${SQL_FILE}:rc=$rc) "
		echo $JOBNAME " File is nonexist(${SQL_FILE}:rc=$rc) "
		exit ${G_RTN_ERROR}
	fi

	# バインド変数を置き換える
	cat ${SQL_FILE} > ${SQL_WORK_FILE}
	
	for bind in $2
	do
		sed -i, -e 0,/?/s/?/"'"$bind"'"/ ${SQL_WORK_FILE}
	done
	
	export SQL_WORK_FILE
}

#
#--- アンロード関数
#       p1：テーブル名／クエリファイル名
EXEC_UNLOAD()
{
	# 出力ファイルの初期化
	cat /dev/null > $2
	rc=$?
	if [ $rc -ne 0 ]
	then
		sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($2:rc=$rc) "
		echo $JOBNAME " File cat error($2:rc=$rc) "
		exit ${G_RTN_ERROR}
	fi
	
	# unload(KK_T_CRECARD)
	sh ${G_TOOLSH}/EOKULD02.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
}
# ANK-4038-00-00 2021/09/30 ADD END


#
#--- ファイルのマッチングを行う
#

export ZTLOUTFILE=${OUTFILE3}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE3}

##
#--- 重複データ削除
#
bsortex -sort key=0.10asc,1.3asc,2.2asc,3.12asc,4.8asc -record recform=txtcsv -input file=${OUTFILE3} reclen=100 -summary suppress last -output file=${MID_DIR_KK}/KKIFM395001_crnt.csv

##
#--- サービス契約回線内訳番号毎に回線内訳使用終了年月日および登録年月日時分秒でソート(料金グループ：ネット)
#
bsortex -sort key=3.12asc,4.8asc,5.17asc -record recform=txtcsv -input file=${MID_DIR_KK}/KKIFM395001_crnt.csv reclen=100 include="(2.2asc.eq.'02'.or.2.2asc.eq.'03'.or.2.2asc.eq.'04')" -output file=${MID_DIR_KK}/KKIFM396001.csv

#
#--- マージ（各キー項目毎のカレントレコードのみを残す）
#
bsortex -merge key=3.12asc -record recform=txtcsv -input file=${MID_DIR_KK}/KKIFM396001.csv reclen=100 -summary suppress last -output file=${MID_DIR_KK}/KKIFM396001_crnt.csv

##
#--- サービス契約回線内訳番号毎に回線内訳使用終了年月日および登録年月日時分秒でソート(料金グループ：電話)
#
bsortex -sort key=3.12asc,4.8asc,5.17asc -record recform=txtcsv -input file=${MID_DIR_KK}/KKIFM395001_crnt.csv reclen=100 include="2.2asc.eq.'10'" -output file=${MID_DIR_KK}/KKIFM397001.csv

#
#--- マージ（各キー項目毎のカレントレコードのみを残す）
#
bsortex -merge key=3.12asc -record recform=txtcsv -input file=${MID_DIR_KK}/KKIFM397001.csv reclen=100 -summary suppress last -output file=${MID_DIR_KK}/KKIFM397001_crnt.csv

##
#--- サービス契約回線内訳番号毎に回線内訳使用終了年月日および登録年月日時分秒でソート(料金グループ：ＴＶ)
#
bsortex -sort key=3.12asc,4.8asc,5.17asc -record recform=txtcsv -input file=${MID_DIR_KK}/KKIFM395001_crnt.csv reclen=100 include="(2.2asc.eq.'11'.or.2.2asc.eq.'12'.or.2.2asc.eq.'13')" -output file=${MID_DIR_KK}/KKIFM398001.csv

#
#--- マージ（各キー項目毎のカレントレコードのみを残す）
#
bsortex -merge key=3.12asc -record recform=txtcsv -input file=${MID_DIR_KK}/KKIFM398001.csv reclen=100 -summary suppress last -output file=${MID_DIR_KK}/KKIFM398001_crnt.csv

export ZTLOUTFILE=${OUTFILE4}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE4}

export ZTLOUTFILE=${OUTFILE}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE1}

##
#--- サービス契約番号毎に終了年月日および登録年月日時分秒でソート
#
bsortex -sort key=0.10asc,3.8asc,2.17asc -record recform=txtcsv -input file=${OUTFILE} reclen=150 -output file=${MID_DIR_KK}/KKIFM393001_sort.csv

#
#--- マージ（各キー項目毎のカレントレコードのみを残す）
#
bsortex -merge key=0.10asc -record recform=txtcsv -input file=${MID_DIR_KK}/KKIFM393001_sort.csv reclen=150 -summary suppress last -output file=${MID_DIR_KK}/KKIFM393001_crnt.csv reconst="0.10,1.64"


export ZTLOUTFILE=${OUTFILE2}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE2}

#
#--- サービス契約回線内訳番号毎に登録年月日時分秒でソート
#
bsortex -sort key=1.12asc,4.17asc -record recform=txtcsv -input file=${OUTFILE2} reclen=110 -output file=${MID_DIR_KK}/KKIFM394002.csv

##
#--- 重複削除
#
bsortex -merge key=1.12asc -record recform=txtcsv -input file=${MID_DIR_KK}/KKIFM394002.csv reclen=110 -summary suppress last -output file=${MID_DIR_KK}/KKIFM394004.csv reconst="0.10,1.12,3.1"

export ZTLOUTFILE=${OUTFILE6}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE6}

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

##
#--- 抽出条件
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE4} reclen=200 include="(7.3asc.eq.'910'.or.7.3asc.eq.'920'.or.7.1asc.le.'0').and.(9.3asc.ne.'910'.and.9.3asc.ne.'920'.and.9.1asc.gt.'0')" -output file=${MID_DIR_KK}/KKIFM399002.csv reconst="0.10,'1'.1ascA"

##
#--- 抽出条件
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE4} reclen=200 omit="(7.3asc.eq.'910'.or.7.3asc.eq.'920'.or.7.1asc.le.'0').and.(9.3asc.ne.'910'.and.9.3asc.ne.'920'.and.9.1asc.gt.'0')" -output file=${MID_DIR_KK}/KKIFM399003.csv reconst="0.10,'0'.1ascA"

#
#---ＣＡＴ
#
cat ${MID_DIR_KK}/KKIFM399002.csv ${MID_DIR_KK}/KKIFM399003.csv > ${MID_DIR_KK}/KKIFM399004.csv

#--- v10.00.00 2014/08/12 ADD START
#
#--- ファイルのマッチングを行う (ファミリーパック契約有無情報)
#
export ZTLOUTFILE=${OUTFILE7}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE7}

##
#--- 抽出条件 (ファミリーパック契約有)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE7} reclen=30 include="1.1asc.ge.'0'" -output file=${MID_DIR_KK}/KKIFM623003.csv reconst="0.10,'1'.1ascA"

##
#--- 抽出条件 (ファミリーパック契約無)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE7} reclen=30 include="1.1asc.lt.'0'" -output file=${MID_DIR_KK}/KKIFM623004.csv reconst="0.10,'0'.1ascA"

#
#---ＣＡＴ (ファミリーパック契約有無情報ファイル結合)
#
cat ${MID_DIR_KK}/KKIFM623003.csv ${MID_DIR_KK}/KKIFM623004.csv > ${MID_DIR_KK}/KKIFM623005.csv

#
#--- ファイルのマッチングを行う (Eメール有無情報)
#
export ZTLOUTFILE=${OUTFILE8}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE8}

##
#--- 抽出条件 (Eメール有)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE8} reclen=30 include="1.1asc.gt.'0'" -output file=${MID_DIR_KK}/KKIFM624003_b001.csv

##
#--- 抽出条件 (Eメール無)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE8} reclen=30 include="1.1asc.le.'0'" -output file=${MID_DIR_KK}/KKIFM624004_b001.csv reconst="0.10,'0'.1ascA"

#
#---ＣＡＴ (Eメール有無情報ファイル結合)
#
cat ${MID_DIR_KK}/KKIFM624003_b001.csv ${MID_DIR_KK}/KKIFM624004_b001.csv > ${MID_DIR_KK}/KKIFM624005_b001.csv

#
#--- ファイルのマッチングを行う (リモートサポートプラス有無情報)
#
export ZTLOUTFILE=${OUTFILE9}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE9}

##
#--- 抽出条件 (リモートサポートプラス有)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE9} reclen=30 include="1.1asc.ge.'0'" -output file=${MID_DIR_KK}/KKIFM624003_b021.csv reconst="0.10,'1'.1ascA"

##
#--- 抽出条件 (リモートサポートプラス無)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE9} reclen=30 include="1.1asc.lt.'0'" -output file=${MID_DIR_KK}/KKIFM624004_b021.csv reconst="0.10,'0'.1ascA"

#
#---ＣＡＴ (リモートサポートプラス有無情報ファイル結合)
#
cat ${MID_DIR_KK}/KKIFM624003_b021.csv ${MID_DIR_KK}/KKIFM624004_b021.csv > ${MID_DIR_KK}/KKIFM624005_b021.csv

#
#--- ファイルのマッチングを行う (スマートリンクプレミアム有無情報)
#
export ZTLOUTFILE=${OUTFILE10}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE10}

##
#--- 抽出条件 (スマートリンクプレミアム有)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE10} reclen=30 include="1.1asc.ge.'0'" -output file=${MID_DIR_KK}/KKIFM624003_b077.csv reconst="0.10,'1'.1ascA"

##
#--- 抽出条件 (スマートリンクプレミアム無)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE10} reclen=30 include="1.1asc.lt.'0'" -output file=${MID_DIR_KK}/KKIFM624004_b077.csv reconst="0.10,'0'.1ascA"

#
#---ＣＡＴ (スマートリンクプレミアム有無情報ファイル結合)
#
cat ${MID_DIR_KK}/KKIFM624003_b077.csv ${MID_DIR_KK}/KKIFM624004_b077.csv > ${MID_DIR_KK}/KKIFM624005_b077.csv

# ANK-4346-00-00 2023/02/13 DEL START
##
##--- ファイルのマッチングを行う (ウィルスバスター有無情報)
##
#export ZTLOUTFILE=${OUTFILE11}
#${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE11}
#
##
##--- 抽出条件 (ウィルスバスター有)
##
#bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE11} reclen=30 include="1.1asc.ge.'0'" -output file=${MID_DIR_KK}/KKIFM626003_virus.csv reconst="0.10,'1'.1ascA"
#
##
##--- 抽出条件 (ウィルスバスター無)
##
#bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE11} reclen=30 include="1.1asc.lt.'0'" -output file=${MID_DIR_KK}/KKIFM626004_virus.csv reconst="0.10,'0'.1ascA"
#
##
##---ＣＡＴ (ウィルスバスター有無情報ファイル結合)
##
#cat ${MID_DIR_KK}/KKIFM626003_virus.csv ${MID_DIR_KK}/KKIFM626004_virus.csv > ${MID_DIR_KK}/KKIFM626005_virus.csv
#
##
##--- ファイルのマッチングを行う (web有害フィルター有無情報)
##
#export ZTLOUTFILE=${OUTFILE12}
#${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE12}
#
##
##--- 抽出条件 (web有害フィルター有)
##
#bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE12} reclen=30 include="1.1asc.ge.'0'" -output file=${MID_DIR_KK}/KKIFM626003_web.csv reconst="0.10,'1'.1ascA"
#
##
##--- 抽出条件 (web有害フィルター無)
##
#bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE12} reclen=30 include="1.1asc.lt.'0'" -output file=${MID_DIR_KK}/KKIFM626004_web.csv reconst="0.10,'0'.1ascA"
#
##
##---ＣＡＴ (web有害フィルター有無情報ファイル結合)
##
#cat ${MID_DIR_KK}/KKIFM626003_web.csv ${MID_DIR_KK}/KKIFM626004_web.csv > ${MID_DIR_KK}/KKIFM626005_web.csv
# ANK-4346-00-00 2023/02/13 DEL END

#
#--- ファイルのマッチングを行う (ウィルスチェック有無情報)
#
export ZTLOUTFILE=${OUTFILE13}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE13}

##
#--- 抽出条件 (ウィルスチェック有)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE13} reclen=30 include="1.1asc.gt.'0'" -output file=${MID_DIR_KK}/KKIFM625003.csv

##
#--- 抽出条件 (ウィルスチェック無)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE13} reclen=30 include="1.1asc.le.'0'" -output file=${MID_DIR_KK}/KKIFM625004.csv reconst="0.10,'0'.1ascA"

#
#---ＣＡＴ (ウィルスチェック有無情報ファイル結合)
#
cat ${MID_DIR_KK}/KKIFM625003.csv ${MID_DIR_KK}/KKIFM625004.csv > ${MID_DIR_KK}/KKIFM625005.csv

#
#--- ファイルのマッチングを行う (連絡先(連絡先種別コード=5:その他))
#
export ZTLOUTFILE=${OUTFILE14}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE14}

##
#--- 抽出条件 (連絡先の電話番号有)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE14} reclen=50 include="2.12asc.ge.'0'" -output file=${MID_DIR_KK}/KKIFM379003_other.csv reconst="0.10,'5'.1ascA,2.12"

##
#--- 抽出条件 (連絡先の電話番号無)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE14} reclen=50 include="2.12asc.lt.'0'" -output file=${MID_DIR_KK}/KKIFM379004_other.csv reconst="0.10,'5'.1ascA,3.11"

#
#---ＣＡＴ (連絡先ファイル結合)
#
cat ${MID_DIR_KK}/KKIFM379003_other.csv ${MID_DIR_KK}/KKIFM379004_other.csv > ${MID_DIR_KK}/KKIFM379005_other.csv
#--- v10.00.00 2014/08/12 ADD END

# ANK-3149-00-00 2017/04/03 ADD START
#--- ファイルのマッチングを行う (セキュリティパック契約有無情報)
#
export ZTLOUTFILE=${OUTFILE15}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE15}

##
#--- 抽出条件 (セキュリティパック契約有)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE15} reclen=30 include="1.1asc.ge.'0'" -output file=${MID_DIR_KK}/KKIFM728003.csv reconst="0.10,'1'.1ascA"

##
#--- 抽出条件 (セキュリティパック契約無)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE15} reclen=30 include="1.1asc.lt.'0'" -output file=${MID_DIR_KK}/KKIFM728004.csv reconst="0.10,'0'.1ascA"

#
#---ＣＡＴ (セキュリティパック契約有無情報ファイル結合)
#
cat ${MID_DIR_KK}/KKIFM728003.csv ${MID_DIR_KK}/KKIFM728004.csv > ${MID_DIR_KK}/KKIFM728005.csv

#--- ファイルのマッチングを行う (インターネットサギウォール有無情報)
#
export ZTLOUTFILE=${OUTFILE16}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE16}

##
#--- 抽出条件 (インターネットサギウォール有)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE16} reclen=30 include="1.1asc.ge.'0'" -output file=${MID_DIR_KK}/KKIFM624003_b131.csv reconst="0.10,'1'.1ascA"

##
#--- 抽出条件 (インターネットサギウォール無)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE16} reclen=30 include="1.1asc.lt.'0'" -output file=${MID_DIR_KK}/KKIFM624004_b131.csv reconst="0.10"

#--- ファイルのマッチングを行う (ノートンファミリープレミア有無情報)
#
export ZTLOUTFILE=${OUTFILE17}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE17}

##
#--- 抽出条件 (ノートンファミリープレミア有)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE17} reclen=30 include="1.1asc.ge.'0'" -output file=${MID_DIR_KK}/KKIFM624003_b132.csv reconst="0.10,'2'.1ascA"

##
#--- 抽出条件 (ノートンファミリープレミア無)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE17} reclen=30 include="1.1asc.lt.'0'" -output file=${MID_DIR_KK}/KKIFM624004_b132.csv reconst="0.10"

# ANK-3149-00-00 2017/04/03 ADD END
# ANK-3149-09-00 2017/04/28 ADD START
#
#---ファイルのマッチングを行う (インターネットサギウォール、ノートンファミリープレミア有情報)
#
export ZTLOUTFILE=${OUTFILE18}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE18}

##
#--- ソート (インターネットサギウォール、ノートンファミリープレミア有情報)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE18} reclen=30 -output file=${MID_DIR_KK}/KKIFM624003_sort_b131b132.csv reconst="0.10,'3'.1ascA"

#
#---ファイルのマッチングを行う (インターネットサギウォール、ノートンファミリープレミア無情報)
#
export ZTLOUTFILE=${OUTFILE19}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE19}

##
#--- ソート (インターネットサギウォール、ノートンファミリープレミア無情報)
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE19} reclen=30 -output file=${MID_DIR_KK}/KKIFM624004_sort_b131b132.csv reconst="0.10,'0'.1ascA"

#
#---ＣＡＴ (セキュリティオプション契約有無情報ファイル結合)
#
cat ${MID_DIR_KK}/KKIFM624003_b131.csv ${MID_DIR_KK}/KKIFM624003_b132.csv ${MID_DIR_KK}/KKIFM624003_sort_b131b132.csv ${MID_DIR_KK}/KKIFM624004_sort_b131b132.csv > ${MID_DIR_KK}/KKIFM624005_b131b132.csv

##
#--- ソート (インターネットサギウォール、ノートンファミリープレミア無情報)
#
bsortex -sort key=0.10asc,1.1asc -record recform=txtcsv -input file=${MID_DIR_KK}/KKIFM624005_b131b132.csv reclen=100 -output file=${MID_DIR_KK}/KKIFM624005_sort_b131b132.csv

#
#--- マージ（各キー項目毎のカレントレコードのみを残す）
#
bsortex -merge key=0.10asc -record recform=txtcsv -input file=${MID_DIR_KK}/KKIFM624005_sort_b131b132.csv reclen=100 -summary suppress last -output file=${MID_DIR_KK}/KKIFM624005_crnt_b131b132.csv

# ANK-3149-09-00 2017/04/28 ADD END
# ANK-3366-01-00 2018/05/10 ADD START
##
#--- 卸先事業者毎に世代登録年月日時分秒でソート
#
bsortex -sort key=0.2asc,1.17asc,3.8asc -record recform=txtcsv -input file=$TMPFILE_CCIFM046 reclen=350 include="3.8asc.le.'${RSLT_OPEDATE}'" -output file=$TMPFILE_CCIFM047_SORT reconst="0.2,1.17,2.242,3.8"

#--- マージ（各キー項目毎のカレントレコードのみを残す）
#
bsortex -merge key=0.2asc -record recform=txtcsv -input file=$TMPFILE_CCIFM047_SORT reclen=300 -summary suppress last -output file=$TMPFILE_CCIFM047_CRNT

# ANK-3366-01-00 2018/05/10 ADD END
# ANK-3653-00-00 2019/06/03 ADD START
#--- サービス契約番号毎にサービスコードでソート
#
bsortex -sort key=1.12asc,6.2asc -record recform=txtcsv -input file=${OUTFILE4} reclen=200 include="(6.2asc.eq.'01'.or.6.2asc.eq.'02')" -output file=${MID_DIR_KK}/KKIFM878001_sort.csv reconst="0.10,1.12,6.2"

#--- マージ（サービス契約回線内訳単位でネットもしくは電話のレコードを残す）
#
bsortex -merge key=1.12asc -record recform=txtcsv -input file=${MID_DIR_KK}/KKIFM878001_sort.csv reclen=100 -summary suppress first -output file=${MID_DIR_KK}/KKIFM878002.csv reconst="0.10,1.12"

#--- ファイルのマッチングを行う (工事案件番号情報)
#
export ZTLOUTFILE=${OUTFILE21}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE21}

#--- ファイルのマッチングを行う (認証ID情報)
#
export ZTLOUTFILE=${OUTFILE22}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE22}

#--- ファイルのマッチングを行う (TV関連工事案件番号情報)
#
export ZTLOUTFILE=${OUTFILE23}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE23}

#--- ファイルのマッチングを行う (TV関連認証ID情報)
#
export ZTLOUTFILE=${OUTFILE24}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE24}

#---ＣＡＴ (eo光ネット認証IDファイル結合)
#
cat ${MID_DIR_KK}/KKIFM393001_crnt.csv ${MID_DIR_KK}/KKIFM878006.csv > ${MID_DIR_KK}/KKIFM878007.csv


# ANK-3653-00-00 2019/06/03 ADD END
# ANK-3366-16-00 2018/05/30 ADD START
sh ${G_TOOLSH}/EOK010210J0.sh CS00027I $JOBNAME

#
#---ＡＰＬ起動
#

java ${JAVA_OPTION} -jar ${JAR_DIR}/koptBatch.jar $PARA

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

sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
# ANK-3366-16-00 2018/05/30 ADD END

# ANK-2990-00-00 2016/10/03 ADD START
#
#--- ファイルマッチング
#
export ZTLOUTFILE=$TMPFILE_KKIFM718
# マッチングファイル（回線対象サービス契約）カレント
export OUTFILE3_CRNT=${MID_DIR_KK}/KKIFM395001_crnt.csv
# 同一場所ｅｏ電気契約マージファイル
export TMPFILE_KKIFM717_MERGE=${LOC_DIR_KK}/KKIFM717001_merge.csv
${G_TOOLSH}/util/bin/ZTLMAT01 $MATCHDEF_KK0241

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " MATCHING error($MATCHDEF_KK0241 matching:rc=$rc) "
    echo $JOBNAME " MATCHING error($MATCHDEF_KK0241 matching:rc=$rc) "
    exit ${G_RTN_ERROR}
fi
# IT1-2017-0000007 2017/02/20 DEL START
# export TMPFILE_KKIFM718
# IT1-2017-0000007 2017/02/20 DEL END
# ANK-2990-00-00 2016/10/03 ADD END

# IT1-2017-0000007 2017/02/20 ADD START
#
#--- 重複データ削除
#
# bsort用項目定義
BSORT_DEF_KKIFM718_CRNT="@SVC_KEI_KAISEN_UCWK_NO=0.12 @YMD_CLM=1.8"
bsortex -define $BSORT_DEF_KKIFM718_CRNT -sort key=@SVC_KEI_KAISEN_UCWK_NOasc,@YMD_CLMasc -record recform=txtcsv \
        -input file=$TMPFILE_KKIFM718 reclen=30 -summary suppress last \
        -output file=$TMPFILE_KKIFM718_CRNT

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

export TMPFILE_KKIFM718_CRNT
# IT1-2017-0000007 2017/02/20 ADD END

export ZTLOUTFILE=${OUTFILE5}
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE5}

##
#--- システム日付取得
#
. EOK010410J0.sh 1

##
#--- 抽出条件
#
# ANK-2990-00-00 2016/10/03 MOD START
# #--- v10.00.00 2014/08/12 MOD START
# #bsortex -copy -record recform=txtcsv -input file=${OUTFILE5} reclen=3500 -output file=${MID_DIR_KK}/KKIFM401001_crnt.csv reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA"
# bsortex -copy -record recform=txtcsv -input file=${OUTFILE5} reclen=4000 -output file=${MID_DIR_KK}/KKIFM401001_crnt.csv reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA"
# #--- v10.00.00 2014/08/12 MOD END
# ANK-3149-00-00 2017/04/03 DEL START
#bsortex -copy -record recform=txtcsv -input file=${OUTFILE5} reclen=4010 -output file=${MID_DIR_KK}/KKIFM401001_crnt.csv reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA"
# ANK-3149-00-00 2017/04/03 DEL END
# ANK-2990-00-00 2016/10/03 MOD END
# ANK-3366-01-00 2018/05/10 DEL START
# ANK-3149-00-00 2017/04/03 ADD START
#bsortex -copy -record recform=txtcsv -input file=${OUTFILE5} reclen=4022 -output file=${MID_DIR_KK}/KKIFM401001_crnt.csv reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA"
# ANK-3149-00-00 2017/04/03 ADD END
# ANK-3366-01-00 2018/05/10 DEL END
# ANK-3563-00-00 2019/06/03 DEL START
# ANK-3366-01-00 2018/05/10 ADD START
#bsortex -copy -record recform=txtcsv -input file=${OUTFILE5} reclen=4322 -output file=${MID_DIR_KK}/KKIFM401001_crnt.csv reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA"
# ANK-3366-01-00 2018/05/10 ADD END
# ANK-3563-00-00 2019/06/03 DEL END
# ANK-4038-00-00 2021/09/30 MOD START
# ANK-3653-00-00 2019/06/03 ADD START
#bsortex -copy -record recform=txtcsv -input file=${OUTFILE5} reclen=4335 -output file=${MID_DIR_KK}/KKIFM401001_crnt.csv reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA"
# ANK-3653-00-00 2019/06/03 ADD END
# ANK-4038-05-00 2021/11/04 MOD START
#bsortex -copy -record recform=txtcsv -input file=${OUTFILE5} reclen=4405 -output file=${OUTFILE25_TMP} reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.1,52.1,53.3,54.3,55.1,56.20,57.20,58.20,59.1,60.2,61.3,62.2,63.3,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA"
# ANK-4038-00-00 2021/09/30 MOD END
# ANK-4269-00-00 2022/08/09 MOD START
#bsortex -copy -record recform=txtcsv -input file=${OUTFILE5} reclen=4405 -output file=${OUTFILE25_TMP} reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,60.2,61.3,62.2,63.3,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA"
# ANK-4038-05-00 2021/11/04 MOD END
# ANK-4244-14-00 2022/09/09 MOD START
#bsortex -copy -record recform=txtcsv -input file=${OUTFILE5} reclen=4570 -output file=${OUTFILE26_TMP} reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,60.2,61.3,62.2,63.3,64.160,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA"
# ANK-4346-00-00 2023/02/13 MOD START
#bsortex -copy -record recform=txtcsv -input file=${OUTFILE5} reclen=4570 -output file=${OUTFILE26_TMP} reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,60.2,61.3,62.2,63.3,64.160,65.1,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA"
bsortex -copy -record recform=txtcsv -input file=${OUTFILE5} reclen=4570 -output file=${OUTFILE26_TMP} reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,' '.1ascA,' '.1ascA,42.2,43.2,44.8,45.2,46.82,47.242,48.10,49.2,50.2,51.3,52.3,53.2,54.20,55.20,56.20,57.2,58.2,59.3,60.2,61.3,62.160,63.1,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA"
# ANK-4346-00-00 2023/02/13 MOD END
# ANK-4244-14-00 2022/09/09 MOD END
# ANK-4269-00-00 2022/08/09 MOD END

# ANK-4269-00-00 2022/08/09 ADD START
#
#---卸事業者名（スキーム事業者名）を設定
#
# ANK-4244-14-00 2022/09/09 MOD START
#bsortex -copy -record recform=txtcsv \
#        -input file=${OUTFILE26_TMP} reclen=4570 \
#       -output reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,64.160,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,60.2,61.3,62.2,63.3,64.160,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE31} case="49.242asc.lt.'0'.and.64.160asc.ge.'0'" \
#       -output reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,60.2,61.3,62.2,63.3,64.160,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE32} case=other 
bsortex -copy -record recform=txtcsv \
        -input file=${OUTFILE26_TMP} reclen=4570 \
        -output reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,64.160,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,60.2,61.3,62.2,63.3,64.160,65.1,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE31} case="49.242asc.lt.'0'.and.64.160asc.ge.'0'" \
        -output reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,60.2,61.3,62.2,63.3,64.160,65.1,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE32} case=other 
 # ANK-4244-14-00 2022/09/09 MOD END
#
#--- マージ処理、一時ファイル削除処理
#
cat ${OUTFILE31} > ${OUTFILE25_TMP}
cat ${OUTFILE32} >> ${OUTFILE25_TMP}
rm ${OUTFILE26_TMP}
# ANK-4269-00-00 2022/08/09 ADD END

# ANK-4038-00-00 2021/09/30 ADD START
# 光コンセント料金プラン名称（１Ｇダミー）
WORK_PARAM_ID=KK_MANS_C_PPLANNM_01
EDIT_ULD_QUERY ${ZM0321_ULD_QUERY} "${WORK_PARAM_ID} ${RSLT_OPEDATE} ${RSLT_OPEDATE}"
EXEC_UNLOAD ${SQL_WORK_FILE} ${ZM0321_OUTFILE}
read EXECDATE_DQ < ${ZM0321_OUTFILE}
# ダブルクォーテーション削除
MANS_C_PPLANNM_01=`echo ${EXECDATE_DQ} | sed -e 's/"//g'`
rm ${ZM0321_OUTFILE}

# 光コンセント料金プラン名称（５Ｇダミー）
WORK_PARAM_ID=KK_MANS_C_PPLANNM_02
EDIT_ULD_QUERY ${ZM0321_ULD_QUERY} "${WORK_PARAM_ID} ${RSLT_OPEDATE} ${RSLT_OPEDATE}"
EXEC_UNLOAD ${SQL_WORK_FILE} ${ZM0321_OUTFILE}
read EXECDATE_DQ < ${ZM0321_OUTFILE}
# ダブルクォーテーション削除
MANS_C_PPLANNM_02=`echo ${EXECDATE_DQ} | sed -e 's/"//g'`
rm ${ZM0321_OUTFILE}

# 光コンセント料金プラン名称（１０Ｇダミー）
WORK_PARAM_ID=KK_MANS_C_PPLANNM_03
EDIT_ULD_QUERY ${ZM0321_ULD_QUERY} "${WORK_PARAM_ID} ${RSLT_OPEDATE} ${RSLT_OPEDATE}"
EXEC_UNLOAD ${SQL_WORK_FILE} ${ZM0321_OUTFILE}
read EXECDATE_DQ < ${ZM0321_OUTFILE}
# ダブルクォーテーション削除
MANS_C_PPLANNM_03=`echo ${EXECDATE_DQ} | sed -e 's/"//g'`
rm ${ZM0321_OUTFILE}

# 業務パラメータ設定値のByte数を設定する
PPLANNM_BYTE_1=`echo ${#MANS_C_PPLANNM_01}`
PPLANNM_BYTE_2=`echo ${#MANS_C_PPLANNM_02}`
PPLANNM_BYTE_3=`echo ${#MANS_C_PPLANNM_03}`

# ANK-4244-14-00 2022/09/06 ADD START
# ＭＴ（光配線）料金プラン名称（１Ｇダミー）
WORK_PARAM_ID=KK_MANS_PPLANNM_01
EDIT_ULD_QUERY ${ZM0321_ULD_QUERY} "${WORK_PARAM_ID} ${RSLT_OPEDATE} ${RSLT_OPEDATE}"
EXEC_UNLOAD ${SQL_WORK_FILE} ${ZM0321_OUTFILE}
read EXECDATE_DQ < ${ZM0321_OUTFILE}
# ダブルクォーテーション削除
MANS_PPLANNM_01=`echo ${EXECDATE_DQ} | sed -e 's/"//g'`
rm ${ZM0321_OUTFILE}

# ＭＴ（光配線）料金プラン名称（５Ｇダミー）
WORK_PARAM_ID=KK_MANS_PPLANNM_02
EDIT_ULD_QUERY ${ZM0321_ULD_QUERY} "${WORK_PARAM_ID} ${RSLT_OPEDATE} ${RSLT_OPEDATE}"
EXEC_UNLOAD ${SQL_WORK_FILE} ${ZM0321_OUTFILE}
read EXECDATE_DQ < ${ZM0321_OUTFILE}
# ダブルクォーテーション削除
MANS_PPLANNM_02=`echo ${EXECDATE_DQ} | sed -e 's/"//g'`
rm ${ZM0321_OUTFILE}

# ＭＴ（光配線）料金プラン名称（１０Ｇダミー）
WORK_PARAM_ID=KK_MANS_PPLANNM_03
EDIT_ULD_QUERY ${ZM0321_ULD_QUERY} "${WORK_PARAM_ID} ${RSLT_OPEDATE} ${RSLT_OPEDATE}"
EXEC_UNLOAD ${SQL_WORK_FILE} ${ZM0321_OUTFILE}
read EXECDATE_DQ < ${ZM0321_OUTFILE}
# ダブルクォーテーション削除
MANS_PPLANNM_03=`echo ${EXECDATE_DQ} | sed -e 's/"//g'`
rm ${ZM0321_OUTFILE}

# 業務パラメータ設定値のByte数を設定する
MANS_PPLANNM_BYTE_1=`echo ${#MANS_PPLANNM_01}`
MANS_PPLANNM_BYTE_2=`echo ${#MANS_PPLANNM_02}`
MANS_PPLANNM_BYTE_3=`echo ${#MANS_PPLANNM_03}`
# ANK-4244-14-00 2022/09/06 ADD END

#
#---マンションタイプ(光コンセント方式)の場合はダミーの料金プラン名を設定
#
# ANK-4038-05-00 2021/11/04 MOD START
#bsortex -copy -record recform=txtcsv \
#        -input file=${OUTFILE25_TMP} reclen=4405 \
#        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_C_PPLANNM_01}'.${PPLANNM_BYTE_1}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.1,52.1,53.3,54.3,55.1,56.20,57.20,58.20,59.1,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE26} case="60.2asc.eq.'04'.and.61.3asc.eq.'008'.and.62.2asc.eq.'51'.and.63.3asc.ne.'008'.and.63.3asc.ne.'009'" \
#        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_C_PPLANNM_02}'.${PPLANNM_BYTE_2}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.1,52.1,53.3,54.3,55.1,56.20,57.20,58.20,59.1,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE27} case="60.2asc.eq.'04'.and.61.3asc.eq.'008'.and.62.2asc.eq.'51'.and.63.3asc.eq.'008'" \
#        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_C_PPLANNM_03}'.${PPLANNM_BYTE_3}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.1,52.1,53.3,54.3,55.1,56.20,57.20,58.20,59.1,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE28} case="60.2asc.eq.'04'.and.61.3asc.eq.'008'.and.62.2asc.eq.'51'.and.63.3asc.eq.'009'" \
#        -output reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.1,52.1,53.3,54.3,55.1,56.20,57.20,58.20,59.1,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE29} case=other 
# ANK-4269-00-00 2022/08/09 MOD START
#bsortex -copy -record recform=txtcsv \
#        -input file=${OUTFILE25_TMP} reclen=4405 \
#        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_C_PPLANNM_01}'.${PPLANNM_BYTE_1}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE26} case="60.2asc.eq.'04'.and.61.3asc.eq.'008'.and.62.2asc.eq.'51'.and.63.3asc.ne.'008'.and.63.3asc.ne.'009'" \
#        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_C_PPLANNM_02}'.${PPLANNM_BYTE_2}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE27} case="60.2asc.eq.'04'.and.61.3asc.eq.'008'.and.62.2asc.eq.'51'.and.63.3asc.eq.'008'" \
#        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_C_PPLANNM_03}'.${PPLANNM_BYTE_3}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE28} case="60.2asc.eq.'04'.and.61.3asc.eq.'008'.and.62.2asc.eq.'51'.and.63.3asc.eq.'009'" \
#        -output reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE29} case=other 
# ANK-4038-05-00 2021/11/04 MOD END
# ANK-4244-14-00 2022/09/06 MOD START
#bsortex -copy -record recform=txtcsv \
#        -input file=${OUTFILE25_TMP} reclen=4570 \
#        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_C_PPLANNM_01}'.${PPLANNM_BYTE_1}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE26} case="60.2asc.eq.'04'.and.61.3asc.eq.'008'.and.62.2asc.eq.'51'.and.63.3asc.ne.'008'.and.63.3asc.ne.'009'" \
#        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_C_PPLANNM_02}'.${PPLANNM_BYTE_2}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE27} case="60.2asc.eq.'04'.and.61.3asc.eq.'008'.and.62.2asc.eq.'51'.and.63.3asc.eq.'008'" \
#        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_C_PPLANNM_03}'.${PPLANNM_BYTE_3}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE28} case="60.2asc.eq.'04'.and.61.3asc.eq.'008'.and.62.2asc.eq.'51'.and.63.3asc.eq.'009'" \
#        -output reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE29} case=other 
bsortex -copy -record recform=txtcsv \
        -input file=${OUTFILE25_TMP} reclen=4570 \
        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_C_PPLANNM_01}'.${PPLANNM_BYTE_1}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE26} case="60.2asc.eq.'04'.and.61.3asc.eq.'008'.and.62.2asc.eq.'51'.and.63.3asc.ne.'008'.and.63.3asc.ne.'009'" \
        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_C_PPLANNM_02}'.${PPLANNM_BYTE_2}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE27} case="60.2asc.eq.'04'.and.61.3asc.eq.'008'.and.62.2asc.eq.'51'.and.63.3asc.eq.'008'" \
        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_C_PPLANNM_03}'.${PPLANNM_BYTE_3}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE28} case="60.2asc.eq.'04'.and.61.3asc.eq.'008'.and.62.2asc.eq.'51'.and.63.3asc.eq.'009'" \
        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_PPLANNM_01}'.${MANS_PPLANNM_BYTE_1}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE33} case="60.2asc.eq.'04'.and.62.2asc.eq.'50'.and.65.1asc.eq.'1'.and.63.3asc.ne.'008'.and.63.3asc.ne.'009'" \
        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_PPLANNM_02}'.${MANS_PPLANNM_BYTE_2}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE34} case="60.2asc.eq.'04'.and.62.2asc.eq.'50'.and.65.1asc.eq.'1'.and.63.3asc.eq.'008'" \
        -output reconst="0.10,1.10,2.10,3.10,4.242,'${MANS_PPLANNM_03}'.${MANS_PPLANNM_BYTE_3}ascA,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE35} case="60.2asc.eq.'04'.and.62.2asc.eq.'50'.and.65.1asc.eq.'1'.and.63.3asc.eq.'009'" \
        -output reconst="0.10,1.10,2.10,3.10,4.242,5.242,6.64,7.160,8.160,9.160,10.8,11.8,12.10,13.242,14.242,15.12,16.242,17.11,18.160,19.80,20.11,21.7,22.32,23.60,24.122,25.90,26.30,27.10,28.242,29.242,30.160,31.160,32.10,33.10,34.10,35.80,36.7,37.360,38.12,39.2,40.10,41.10,42.2,43.2,44.2,45.2,46.8,47.2,48.82,49.242,50.10,51.2,52.2,53.3,54.3,55.2,56.20,57.20,58.20,59.2,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,'${RSLT_SYSDATE}'.17ascA,'SYSTEM'.6ascA,' '.1ascA,' '.1ascA,'0'.1ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,'${RSLT_OPEDATE}'.8ascA,'${JOBNAME}'.11ascA,' '.1ascA,' '.1ascA" file=${OUTFILE29} case=other 
# ANK-4269-00-00 2022/08/09 MOD END
# ANK-4244-14-00 2022/09/06 MOD END

#
#--- マージ処理
#
cat ${OUTFILE26} > ${OUTFILE30}
cat ${OUTFILE27} >> ${OUTFILE30}
cat ${OUTFILE28} >> ${OUTFILE30}
cat ${OUTFILE29} >> ${OUTFILE30}
# ANK-4244-14-00 2022/09/06 ADD START
cat ${OUTFILE33} >> ${OUTFILE30}
cat ${OUTFILE34} >> ${OUTFILE30}
cat ${OUTFILE35} >> ${OUTFILE30}
# ANK-4244-14-00 2022/09/06 ADD END


#
#--- 終了処理
#
# 一時ファイル削除
rm ${OUTFILE26}
rm ${OUTFILE27}
rm ${OUTFILE28}
rm ${OUTFILE29}
# ANK-4244-14-00 2022/09/06 ADD START
rm ${OUTFILE33}
rm ${OUTFILE34}
rm ${OUTFILE35}
# ANK-4244-14-00 2022/09/06 ADD END
# ANK-4038-00-00 2021/09/30 ADD END
# ANK-4269-00-00 2022/08/09 ADD START
rm ${OUTFILE31}
rm ${OUTFILE32}
# ANK-4269-00-00 2022/08/09 ADD END

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

exit $exit_rc
