#!/bin/bash
##############################################################
# システム名    ：eo顧客基幹システム
#
# サブシステム名：顧客管理
#
# シェル名      ：機器オプションサービス契約開始日変更抽出
#
# 機能          ：サービス開始年月日/サービス課金開始年月日の変更があったサービス契約に紐付く機器オプションを抽出する。
#
# コマンド形式  ：EO2092320J0.sh
#
# 実行環境      ：.../app/shl
#
# 終了ステータス：ゼロ以外異常
#
# 特記事項      ：特になし
#
# 変更履歴      ：変更日      変更者       障害／仕様変更No.
# v7.00.00       2014/05/19   FJ)山野     【OM-2014-0000148】障害対応
# v8.00.01       2014/07/22   FAP)古内     ST4-2014-0000043
# v8.00.02       2014/07/22   FAP)古内     ST4-2014-0000044
# v9.00.00       2014/09/01   YSK)米谷     IT1-2014-0000290
# v10.00.00      2014/09/09   YSK)起塚     IT2-2014-0000299
# v10.00.01      2014/10/07   YSK)柿坂     ST4-2014-0000063（アンロード統合対応：機器提供サービス契約）
# v10.00.02      2014/10/07   YSK)柿坂     ST4-2014-0000064（アンロード統合対応：サービス契約）
# v20.00.00      2015/11/18   FJ)有本       OM-2015-0003006（性能改善対応：不要なソート削除）
#
##############################################################

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

#
#---ツール格納場所
#
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 "BDATE"
   OPD=${RSLT_OPEDATE}
else
   RSLT_OPEDATE=${OPD}
fi

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

P1="OPD=$OPD,"
P2="SVCCTL=,"
P3="JOB=EO2092320J0,"
P4="IND1=,"
P5="INF1=,"
P6="IND2=,"
P7="INF2=,"
P8="OTD1=KKIFM569.def,"
P9="OTF1=${MID_DIR_KK}/KKIFM569.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

#--- TAI-2014-0000014 追加開始 ---
#
#--- クエリ編集
#       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
}
#--- TAI-2014-0000014 追加終了 ---

#
#--- マッチング処理
#      p1：出力ファイルパス
#      p2：DEFファイルパス
#      p3：TMPDEFファイルパス
EXEC_MATCHING()
{
   OUTFILE=$1
   DEF=$2
   TMPDEF=$3

   # 出力ファイルの初期化
   cat /dev/null > ${OUTFILE}
   cat /dev/null > ${TMPDEF}
   rc=$?
   if [ $rc -ne 0 ]
   then
      sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error(${OUTFILE}:rc=$rc) "
      echo $JOBNAME " File cat error(${OUTFILE}:rc=$rc) "
      exit ${G_RTN_ERROR}
   fi

   # DEFTMPファイル作成
   cat ${DEF}>${TMPDEF}
   # ++++++++++++++ v8.00.01 mod start ++++++++++++++
   #sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEF}
   sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEF}
   sed -i -e s@'${LOC_DIR_KK}'@${LOC_DIR_KK}@g ${TMPDEF}
   # ++++++++++++++ v8.00.01 mod end ++++++++++++++

   # マッチング実行
   export ZTLOUTFILE=${OUTFILE}
   ${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEF}
   rc=$?
   if [ $rc -ne 0 ]
   then
      sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " matching error($2:rc=$rc) "
      echo $JOBNAME " matching error($2:rc=$rc) "
      exit ${G_RTN_ERROR}
   fi
}


#
#--- ファイル定義
#

#アンロード用SQLファイル
SQLFILE_KK1451=${SQL_DIR}/KK_U_KK1451_02.sql
# ++++++++++++++ v10.00.02 del start ++++++++++++
#SQLFILE_KK0081=${SQL_DIR}/KK_U_KK0081_86.sql
# ++++++++++++++ v10.00.02 del end ++++++++++++++
SQLFILE_KK0241=${SQL_DIR}/KK_U_KK0241_20.sql
# ++++++++++++++ v10.00.01 mod start ++++++++++++
#SQLFILE_KK0341=${SQL_DIR}/KK_U_KK0341_22.sql
SQLFILE_KK0341_COM=${SQL_DIR}/KK_U_KK0341_31.sql
# ++++++++++++++ v10.00.01 mod end ++++++++++++++
SQLFILE_KK2811=${SQL_DIR}/KK_U_KK2811_07.sql
SQLFILE_KK2851=${SQL_DIR}/KK_U_KK2851_03.sql
SQLFILE_KK0781=${SQL_DIR}/KK_U_KK0781_10.sql
SQLFILE_KK1471=${SQL_DIR}/KK_U_KK1471_03.sql
# ++++++++++++++ v9.00.00 add start ++++++++++++++
SQLFILE_KK2111=${SQL_DIR}/KK_U_KK2111_02.sql
# ++++++++++++++ v9.00.00 add end ++++++++++++++

#アンロード結果出力ファイル
# ++++++++++++++ v8.00.02 del start ++++++++++++++
#SQLOUT_KK1451=${MID_DIR_KK}/KKIFM569_UL_KK1451.csv
# ++++++++++++++ v8.00.02 del end ++++++++++++++
# ++++++++++++++ v8.00.01 mod start ++++++++++++++
#SQLOUT_KK0081=${MID_DIR_KK}/KKIFM569_UL_KK0081.csv
#SQLOUT_KK0241=${MID_DIR_KK}/KKIFM569_UL_KK0241.csv
#SQLOUT_KK0341=${MID_DIR_KK}/KKIFM569_UL_KK0341.csv
#SQLOUT_KK2811=${MID_DIR_KK}/KKIFM569_UL_KK2811.csv
#SQLOUT_KK2851=${MID_DIR_KK}/KKIFM569_UL_KK2851.csv
## ++++++++++++++ v8.00.02 del start ++++++++++++++
##SQLOUT_KK0781=${MID_DIR_KK}/KKIFM569_UL_KK0781.csv
##SQLOUT_KK1471=${MID_DIR_KK}/KKIFM569_UL_KK1471.csv
## ++++++++++++++ v8.00.02 del end ++++++++++++++
SQLOUT_KK0081=${LOC_DIR_KK}/KKIFM569_UL_KK0081.csv
SQLOUT_KK0241=${LOC_DIR_KK}/KKIFM569_UL_KK0241.csv
SQLOUT_KK0341=${LOC_DIR_KK}/KKIFM569_UL_KK0341.csv
SQLOUT_KK2811=${LOC_DIR_KK}/KKIFM569_UL_KK2811.csv
SQLOUT_KK2851=${LOC_DIR_KK}/KKIFM569_UL_KK2851.csv
# ++++++++++++++ v9.00.00 add start ++++++++++++++
SQLOUT_KK2111=${LOC_DIR_KK}/KKIFM569_UL_KK2111.csv
# ++++++++++++++ v9.00.00 add end ++++++++++++++
# ++++++++++++++ v8.00.01 mod end ++++++++++++++

# ++++++++++++++ v10.00.02 add start ++++++++++++
# 統合アンロードファイル(サービス契約-カレント)
KK0081_COM_OTF=${LOC_DIR_KK}/KKIFM608001.csv
# ++++++++++++++ v10.00.02 add end ++++++++++++++

# ++++++++++++++ v10.00.01 add start ++++++++++++
# 統合アンロードファイル(機器提供サービス契約-カレント)
KK0341_COM_OTF=${LOC_DIR_KK}/KKIFM604001.csv
# ++++++++++++++ v10.00.01 add end ++++++++++++++

#bsortexソート結果出力ファイル
# ++++++++++++++ v8.00.02 del start ++++++++++++++
#BSORT_KK1451=${MID_DIR_KK}/KKIFM569_KK1451_SORT.tmp
# ++++++++++++++ v8.00.02 del end ++++++++++++++

# ++++++++++++++ v8.00.01 mod start ++++++++++++++
##BSORT_KK0081=${MID_DIR_KK}/KKIFM569_KK0081_SORT.tmp #--- TAI-2014-0000014 削除 ---
## ++++++++++++++ v8.00.02 del start ++++++++++++++
##BSORT_KK0241=${MID_DIR_KK}/KKIFM569_KK0241_SORT.tmp
## ++++++++++++++ v8.00.02 del end ++++++++++++++
##BSORT_KK0341=${MID_DIR_KK}/KKIFM569_KK0341_SORT.tmp #--- TAI-2014-0000014 削除 ---
##BSORT_KK2811=${MID_DIR_KK}/KKIFM569_KK2811_SORT.tmp #--- TAI-2014-0000014 削除 ---
## ++++++++++++++ v8.00.02 del start ++++++++++++++
##BSORT_KK2851=${MID_DIR_KK}/KKIFM569_KK2851_SORT.tmp
## ++++++++++++++ v8.00.02 del end ++++++++++++++
#BSORT_KK0781=${MID_DIR_KK}/KKIFM569_KK0781_SORT.tmp
## ++++++++++++++ v8.00.02 del start ++++++++++++++
##BSORT_KK1471=${MID_DIR_KK}/KKIFM569_KK1471_SORT.tmp
##BSORT_KK0781=${LOC_DIR_KK}/KKIFM569_KK0781_SORT.tmp
## ++++++++++++++ v8.00.02 del end ++++++++++++++
# ++++++++++++++ v8.00.01 mod end ++++++++++++++

#bsortexマージ結果出力ファイル
# ++++++++++++++ v8.00.01 mod start ++++++++++++++
#BSORTOUT_KK1451=${MID_DIR_KK}/KKIFM569_KK1451.tmp
##BSORTOUT_KK0081=${MID_DIR_KK}/KKIFM569_KK0081.tmp #--- TAI-2014-0000014 削除 ---
#BSORTOUT_KK0241=${MID_DIR_KK}/KKIFM569_KK0241.tmp
##BSORTOUT_KK0341=${MID_DIR_KK}/KKIFM569_KK0341.tmp #--- TAI-2014-0000014 削除 ---
##BSORTOUT_KK2811=${MID_DIR_KK}/KKIFM569_KK2811.tmp #--- TAI-2014-0000014 削除 ---
#BSORTOUT_KK2851=${MID_DIR_KK}/KKIFM569_KK2851.tmp
#BSORTOUT_KK0781=${MID_DIR_KK}/KKIFM569_KK0781.tmp
#BSORTOUT_KK1471=${MID_DIR_KK}/KKIFM569_KK1471.tmp
#BSORTOUT_KKIFM569001=${MID_DIR_KK}/KKIFM569001.tmp
#BSORTOUT_KKIFM569002=${MID_DIR_KK}/KKIFM569002.tmp
#BSORTOUT_KKIFM569003=${MID_DIR_KK}/KKIFM569003.tmp
#BSORTOUT_KKIFM569004=${MID_DIR_KK}/KKIFM569004.tmp
#BSORTOUT_KKIFM569006=${MID_DIR_KK}/KKIFM569006.tmp
BSORTOUT_KK1451=${LOC_DIR_KK}/KKIFM569_KK1451.tmp
BSORTOUT_KK0241=${LOC_DIR_KK}/KKIFM569_KK0241.tmp
BSORTOUT_KK2851=${LOC_DIR_KK}/KKIFM569_KK2851.tmp
BSORTOUT_KK0781=${LOC_DIR_KK}/KKIFM569_KK0781.tmp
BSORTOUT_KK1471=${LOC_DIR_KK}/KKIFM569_KK1471.tmp
BSORTOUT_KKIFM569001=${LOC_DIR_KK}/KKIFM569001.tmp
BSORTOUT_KKIFM569002=${LOC_DIR_KK}/KKIFM569002.tmp
BSORTOUT_KKIFM569003=${LOC_DIR_KK}/KKIFM569003.tmp
BSORTOUT_KKIFM569004=${LOC_DIR_KK}/KKIFM569004.tmp
BSORTOUT_KKIFM569006=${LOC_DIR_KK}/KKIFM569006.tmp
# ++++++++++++++ v8.00.01 mod end ++++++++++++++

#マッチング用defファイル
DEFFILE_KKIFM569001=${G_TOOLSH}/util/def/KK_CM_0350.def
DEFFILE_KKIFM569002=${G_TOOLSH}/util/def/KK_CM_0355.def
DEFFILE_KKIFM569003=${G_TOOLSH}/util/def/KK_CM_0356.def
DEFFILE_KKIFM569004=${G_TOOLSH}/util/def/KK_CM_0357.def
DEFFILE_KKIFM569005=${G_TOOLSH}/util/def/KK_CM_0358.def
DEFFILE_KKIFM569006=${G_TOOLSH}/util/def/KK_CM_0454.def
DEFFILE_KKIFM569007=${G_TOOLSH}/util/def/KK_CM_0468.def
# ++++++++++++++ v9.00.00 add start ++++++++++++++
DEFFILE_KKIFM569008=${G_TOOLSH}/util/def/KK_CM_0526.def
# ++++++++++++++ v9.00.00 add end ++++++++++++++
# ++++++++++++++ v10.00.00 add start ++++++++++++++
DEFFILE_KKIFM569009=${G_TOOLSH}/util/def/KK_CM_0528.def
DEFFILE_KKIFM569010=${G_TOOLSH}/util/def/KK_CM_0529.def
# ++++++++++++++ v10.00.00 add end ++++++++++++++

#マッチング用defテンプファイル
TMPDEFFILE_KKIFM569001=${ULD_WORK_DIR}/KK_CM_0350_tmp.def
TMPDEFFILE_KKIFM569002=${ULD_WORK_DIR}/KK_CM_0355_tmp.def
TMPDEFFILE_KKIFM569003=${ULD_WORK_DIR}/KK_CM_0356_tmp.def
TMPDEFFILE_KKIFM569004=${ULD_WORK_DIR}/KK_CM_0357_tmp.def
TMPDEFFILE_KKIFM569005=${ULD_WORK_DIR}/KK_CM_0358_tmp.def
TMPDEFFILE_KKIFM569006=${ULD_WORK_DIR}/KK_CM_0454_tmp.def
TMPDEFFILE_KKIFM569007=${ULD_WORK_DIR}/KK_CM_0468_tmp.def
# ++++++++++++++ v9.00.00 add start ++++++++++++++
TMPDEFFILE_KKIFM569008=${ULD_WORK_DIR}/KK_CM_0526_tmp.def
# ++++++++++++++ v9.00.00 add end ++++++++++++++
# ++++++++++++++ v10.00.00 add start ++++++++++++++
TMPDEFFILE_KKIFM569009=${ULD_WORK_DIR}/KK_CM_0528_tmp.def
TMPDEFFILE_KKIFM569010=${ULD_WORK_DIR}/KK_CM_0529_tmp.def
# ++++++++++++++ v10.00.00 add end ++++++++++++++

#中間出力ファイル
# ++++++++++++++ v8.00.01 mod start ++++++++++++++
#OUTFILE_KKIFM569001=${MID_DIR_KK}/KKIFM569001.csv
#OUTFILE_KKIFM569002=${MID_DIR_KK}/KKIFM569002.csv
#OUTFILE_KKIFM569003=${MID_DIR_KK}/KKIFM569003.csv
#OUTFILE_KKIFM569004=${MID_DIR_KK}/KKIFM569004.csv
#OUTFILE_KKIFM569005=${MID_DIR_KK}/KKIFM569005.csv
#OUTFILE_KKIFM569006=${MID_DIR_KK}/KKIFM569006_001.csv
OUTFILE_KKIFM569001=${LOC_DIR_KK}/KKIFM569001.csv
OUTFILE_KKIFM569002=${LOC_DIR_KK}/KKIFM569002.csv
OUTFILE_KKIFM569003=${LOC_DIR_KK}/KKIFM569003.csv
OUTFILE_KKIFM569004=${LOC_DIR_KK}/KKIFM569004.csv
OUTFILE_KKIFM569005=${LOC_DIR_KK}/KKIFM569005.csv
OUTFILE_KKIFM569006=${LOC_DIR_KK}/KKIFM569006_001.csv
# ++++++++++++++ v8.00.01 mod end ++++++++++++++
# ++++++++++++++ v9.00.00 add start ++++++++++++++
OUTFILE_KKIFM569008=${LOC_DIR_KK}/KKIFM569008.csv
# ++++++++++++++ v9.00.00 add end ++++++++++++++
# ++++++++++++++ v10.00.00 add start ++++++++++++++
OUTFILE_KKIFM569009=${LOC_DIR_KK}/KKIFM569009.csv
OUTFILE_KKIFM569010=${LOC_DIR_KK}/KKIFM569010.csv
# ++++++++++++++ v10.00.00 add end ++++++++++++++

#中間出力マージファイル
# ++++++++++++++ v8.00.01 mod start ++++++++++++++
#MERGEFILE_KKIFM569001=${MID_DIR_KK}/KKIFM569001_MERGE.csv
#MERGEFILE_KKIFM569002=${MID_DIR_KK}/KKIFM569002_MERGE.csv
#MERGEFILE_KKIFM569003=${MID_DIR_KK}/KKIFM569003_MERGE.csv
#MERGEFILE_KKIFM569004=${MID_DIR_KK}/KKIFM569004_MERGE.csv
#MERGEFILE_KKIFM569005=${MID_DIR_KK}/KKIFM569005_MERGE.csv
#MERGEFILE_KKIFM569006=${MID_DIR_KK}/KKIFM569006_MERGE.csv
MERGEFILE_KKIFM569001=${LOC_DIR_KK}/KKIFM569001_MERGE.csv
MERGEFILE_KKIFM569002=${LOC_DIR_KK}/KKIFM569002_MERGE.csv
MERGEFILE_KKIFM569003=${LOC_DIR_KK}/KKIFM569003_MERGE.csv
MERGEFILE_KKIFM569004=${LOC_DIR_KK}/KKIFM569004_MERGE.csv
MERGEFILE_KKIFM569005=${LOC_DIR_KK}/KKIFM569005_MERGE.csv
MERGEFILE_KKIFM569006=${LOC_DIR_KK}/KKIFM569006_MERGE.csv
# ++++++++++++++ v8.00.01 mod end ++++++++++++++

#出力ファイル
OUTFILE_KKIFM569=${MID_DIR_KK}/KKIFM569.csv

#
#--- 初期処理 前回実施時に出力したファイルを全てクリアする。
#
#アンロード結果出力ファイル
# ++++++++++++++ v8.00.02 del start ++++++++++++++
#cat /dev/null > ${SQLOUT_KK1451}
# ++++++++++++++ v8.00.02 del end ++++++++++++++
cat /dev/null > ${SQLOUT_KK0081}
cat /dev/null > ${SQLOUT_KK0241}
cat /dev/null > ${SQLOUT_KK0341}
cat /dev/null > ${SQLOUT_KK2811}
cat /dev/null > ${SQLOUT_KK2851}
# ++++++++++++++ v8.00.02 del start ++++++++++++++
#cat /dev/null > ${SQLOUT_KK0781}
#cat /dev/null > ${SQLOUT_KK1471}
# ++++++++++++++ v8.00.02 del end ++++++++++++++

#bsortexソート結果出力ファイル
# ++++++++++++++ v8.00.02 del start ++++++++++++++
#cat /dev/null > ${BSORT_KK1451}
# ++++++++++++++ v8.00.02 del end ++++++++++++++
#cat /dev/null > ${BSORT_KK0081} #--- TAI-2014-0000014 削除 ---
# ++++++++++++++ v8.00.02 del start ++++++++++++++
#cat /dev/null > ${BSORT_KK0241}
# ++++++++++++++ v8.00.02 del end ++++++++++++++
#cat /dev/null > ${BSORT_KK0341} #--- TAI-2014-0000014 削除 ---
#cat /dev/null > ${BSORT_KK2811} #--- TAI-2014-0000014 削除 ---
# ++++++++++++++ v8.00.02 del start ++++++++++++++
#cat /dev/null > ${BSORT_KK2851}
#cat /dev/null > ${BSORT_KK0781}
#cat /dev/null > ${BSORT_KK1471}
# ++++++++++++++ v8.00.02 del end ++++++++++++++

#bsortexマージ結果出力ファイル
cat /dev/null > ${BSORTOUT_KK1451}
#cat /dev/null > ${BSORTOUT_KK0081} #--- TAI-2014-0000014 削除 ---
cat /dev/null > ${BSORTOUT_KK0241}
#cat /dev/null > ${BSORTOUT_KK0341} #--- TAI-2014-0000014 削除 ---
#cat /dev/null > ${BSORTOUT_KK2811} #--- TAI-2014-0000014 削除 ---
cat /dev/null > ${BSORTOUT_KK2851}
cat /dev/null > ${BSORTOUT_KK0781}
cat /dev/null > ${BSORTOUT_KK1471}
cat /dev/null > ${BSORTOUT_KKIFM569001}
cat /dev/null > ${BSORTOUT_KKIFM569002}
cat /dev/null > ${BSORTOUT_KKIFM569003}
cat /dev/null > ${BSORTOUT_KKIFM569004}
cat /dev/null > ${BSORTOUT_KKIFM569006}

#中間出力ファイル
cat /dev/null > ${OUTFILE_KKIFM569001}
cat /dev/null > ${OUTFILE_KKIFM569002}
cat /dev/null > ${OUTFILE_KKIFM569003}
cat /dev/null > ${OUTFILE_KKIFM569004}
cat /dev/null > ${OUTFILE_KKIFM569005}
cat /dev/null > ${OUTFILE_KKIFM569006}

#中間出力マージファイル
cat /dev/null > ${MERGEFILE_KKIFM569001}
cat /dev/null > ${MERGEFILE_KKIFM569002}
cat /dev/null > ${MERGEFILE_KKIFM569003}
cat /dev/null > ${MERGEFILE_KKIFM569004}
cat /dev/null > ${MERGEFILE_KKIFM569005}
cat /dev/null > ${MERGEFILE_KKIFM569006}

#出力ファイル
cat /dev/null > ${OUTFILE_KKIFM569}

# ++++++++++++++ v9.00.00 add start ++++++++++++++
cat /dev/null > ${SQLOUT_KK2111}
cat /dev/null > ${TMPDEFFILE_KKIFM569008}
cat /dev/null > ${OUTFILE_KKIFM569008}
# ++++++++++++++ v9.00.00 add end ++++++++++++++

#
#--- 各ファイルの存在チェックを行う
#

#アンロード用sqlファイル
# KK1451
if [ ! -r $SQLFILE_KK1451 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_KK1451) "
    echo $JOBNAME " File is nonexist($SQLFILE_KK1451) "
    exit ${G_RTN_ERROR}
fi

# ++++++++++++++ v10.00.02 del start ++++++++++++
## KK0081
#if [ ! -r $SQLFILE_KK0081 ]
#then
#    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_KK0081) "
#    echo $JOBNAME " File is nonexist($SQLFILE_KK0081) "
#    exit ${G_RTN_ERROR}
#fi
# ++++++++++++++ v10.00.02 del end ++++++++++++++

# KK0241
if [ ! -r $SQLFILE_KK0241 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_KK0241) "
    echo $JOBNAME " File is nonexist($SQLFILE_KK0241) "
    exit ${G_RTN_ERROR}
fi

# ++++++++++++++ v10.00.01 mod start ++++++++++++
# KK0341
#if [ ! -r $SQLFILE_KK0341 ]
#then
#    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_KK0341) "
#    echo $JOBNAME " File is nonexist($SQLFILE_KK0341) "
#    exit ${G_RTN_ERROR}
#fi

# KK0341_COM(統合アンロードSQL)
if [ ! -r $SQLFILE_KK0341_COM ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_KK0341_COM) "
    echo $JOBNAME " File is nonexist($SQLFILE_KK0341_COM) "
    exit ${G_RTN_ERROR}
fi
# ++++++++++++++ v10.00.01 mod end ++++++++++++++

# KK2811
if [ ! -r $SQLFILE_KK2811 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_KK2811) "
    echo $JOBNAME " File is nonexist($SQLFILE_KK2811) "
    exit ${G_RTN_ERROR}
fi

# KK2851
if [ ! -r $SQLFILE_KK2851 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_KK2851) "
    echo $JOBNAME " File is nonexist($SQLFILE_KK2851) "
    exit ${G_RTN_ERROR}
fi

# KK0781
if [ ! -r $SQLFILE_KK0781 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_KK0781) "
    echo $JOBNAME " File is nonexist($SQLFILE_KK0781) "
    exit ${G_RTN_ERROR}
fi

# KK1471
if [ ! -r $SQLFILE_KK1471 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_KK1471) "
    echo $JOBNAME " File is nonexist($SQLFILE_KK1471) "
    exit ${G_RTN_ERROR}
fi

#マッチング用defファイル
#DEFFILE_KKIFM569001
if [ ! -r $DEFFILE_KKIFM569001 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($DEFFILE_KKIFM569001) "
    echo $JOBNAME " File is nonexist($DEFFILE_KKIFM569001) "
    exit ${G_RTN_ERROR}
fi

#DEFFILE_KKIFM569002
if [ ! -r $DEFFILE_KKIFM569002 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($DEFFILE_KKIFM569002) "
    echo $JOBNAME " File is nonexist($DEFFILE_KKIFM569002) "
    exit ${G_RTN_ERROR}
fi

#DEFFILE_KKIFM569003
if [ ! -r $DEFFILE_KKIFM569003 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($DEFFILE_KKIFM569003) "
    echo $JOBNAME " File is nonexist($DEFFILE_KKIFM569003) "
    exit ${G_RTN_ERROR}
fi

#DEFFILE_KKIFM569004
if [ ! -r $DEFFILE_KKIFM569004 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($DEFFILE_KKIFM569004) "
    echo $JOBNAME " File is nonexist($DEFFILE_KKIFM569004) "
    exit ${G_RTN_ERROR}
fi

#DEFFILE_KKIFM569005
if [ ! -r $DEFFILE_KKIFM569005 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($DEFFILE_KKIFM569005) "
    echo $JOBNAME " File is nonexist($DEFFILE_KKIFM569005) "
    exit ${G_RTN_ERROR}
fi

#DEFFILE_KKIFM569006
if [ ! -r $DEFFILE_KKIFM569006 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($DEFFILE_KKIFM569006) "
    echo $JOBNAME " File is nonexist($DEFFILE_KKIFM569006) "
    exit ${G_RTN_ERROR}
fi

#DEFFILE_KKIFM569007
if [ ! -r $DEFFILE_KKIFM569007 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($DEFFILE_KKIFM569007) "
    echo $JOBNAME " File is nonexist($DEFFILE_KKIFM569007) "
    exit ${G_RTN_ERROR}
fi

# ++++++++++++++ v9.00.00 add start ++++++++++++++
# KK2111
if [ ! -r $SQLFILE_KK2111 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_KK2111) "
    echo $JOBNAME " File is nonexist($SQLFILE_KK2111) "
    exit ${G_RTN_ERROR}
fi

#マッチング用defファイル
#DEFFILE_KKIFM569008
if [ ! -r $DEFFILE_KKIFM569008 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($DEFFILE_KKIFM569008) "
    echo $JOBNAME " File is nonexist($DEFFILE_KKIFM569008) "
    exit ${G_RTN_ERROR}
fi
# ++++++++++++++ v9.00.00 add end ++++++++++++++

# ++++++++++++++ v10.00.00 add start ++++++++++++++
#マッチング用defファイル
#DEFFILE_KKIFM569009
if [ ! -r $DEFFILE_KKIFM569009 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($DEFFILE_KKIFM569009) "
    echo $JOBNAME " File is nonexist($DEFFILE_KKIFM569009) "
    exit ${G_RTN_ERROR}
fi

#DEFFILE_KKIFM569010
if [ ! -r $DEFFILE_KKIFM569010 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($DEFFILE_KKIFM569010) "
    echo $JOBNAME " File is nonexist($DEFFILE_KKIFM569010) "
    exit ${G_RTN_ERROR}
fi
# ++++++++++++++ v10.00.00 add end ++++++++++++++

# ++++++++++++++ v10.00.02 add start ++++++++++++
# 統合アンロードファイル
#KK0081_COM_OTF
if [ ! -r $KK0081_COM_OTF ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($KK0081_COM_OTF) "
    echo $JOBNAME " File is nonexist($KK0081_COM_OTF) "
    exit ${G_RTN_ERROR}
fi
# ++++++++++++++ v10.00.02 add end ++++++++++++++

#
#--- UNLOAD処理
#
#KK1451
# +++++++++++++++++++++++++++++++ v8.00.02 mod start +++++++++++++++++++++++++++++++
#sh ${G_TOOLSH}/EOKULD02.sh $SQLFILE_KK1451 $SQLOUT_KK1451 $JOBNAME
#rc=$?
#if [ $rc -ne 0 ]
#then
#    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($SQLOUT_KK1451 unload:rc=$rc) " 
#    echo $JOBNAME " UNLOAD Error($SQLOUT_KK1451 unload:rc=$rc) "
#    exit ${G_RTN_ERROR}
#fi
EDIT_ULD_QUERY ${SQLFILE_KK1451} "${RSLT_OPEDATE}"
sh ${G_TOOLSH}/EOKULD02.sh $SQL_WORK_FILE $BSORTOUT_KK1451 $JOBNAME
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($BSORTOUT_KK1451 unload:rc=$rc) " 
    echo $JOBNAME " UNLOAD Error($BSORTOUT_KK1451 unload:rc=$rc) "
    exit ${G_RTN_ERROR}
fi
# +++++++++++++++++++++++++++++++ v8.00.02 mod end +++++++++++++++++++++++++++++++

# +++++++++++++++++++++++++++++++ v10.00.02 mod start +++++++++++++++++++++++++++++
##--- TAI-2014-0000014 変更開始 ---
###KK0081
##sh ${G_TOOLSH}/EOKULD02.sh $SQLFILE_KK0081 $SQLOUT_KK0081 $JOBNAME
##KK0081 カレント取得
#EDIT_ULD_QUERY ${SQLFILE_KK0081} "${RSLT_OPEDATE}"
#sh ${G_TOOLSH}/EOKULD02.sh $SQL_WORK_FILE $SQLOUT_KK0081 $JOBNAME
##--- TAI-2014-0000014 変更終了 ---
#rc=$?
#if [ $rc -ne 0 ]
#then
#    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($SQLOUT_KK0081 unload:rc=$rc) " 
#    echo $JOBNAME " UNLOAD Error($SQLOUT_KK0081 unload:rc=$rc) "
#    exit ${G_RTN_ERROR}
#fi

# 統合アンロード(サービス契約-カレント)から必要な情報を抽出する
#  - SELECT(reconst)項目は以下
#      0 - 0.10   ：サービス契約番号
#      1 - 5.8    ：予約適用年月日
#      2 - 1.17   ：世代登録年月日時分秒
#      3 - 6.1    ：予約適用コード
#      4 - 7.1    ：無効フラグ
#      5 - 4.2    ：料金グループコード
#      6 - 8.8    ：サービス開始年月日
#      7 - 16.17  ：更新年月日時分秒
#      8 - 3.2    ：サービスコード
#      9 - 9.8    ：サービス課金開始年月日
gawk 'BEGIN {FS=",";OFS=","}
            {print $1,$6,$2,$7,$8,$5,$9,$17,$4,$10}' ${KK0081_COM_OTF} > ${SQLOUT_KK0081}
# +++++++++++++++++++++++++++++++ v10.00.02 mod end +++++++++++++++++++++++++++++++

#KK0241
# +++++++++++++++++++++++++++++++ v8.00.02 mod start +++++++++++++++++++++++++++++++
#sh ${G_TOOLSH}/EOKULD02.sh $SQLFILE_KK0241 $SQLOUT_KK0241 $JOBNAME
EDIT_ULD_QUERY ${SQLFILE_KK0241} "${RSLT_OPEDATE}"
sh ${G_TOOLSH}/EOKULD02.sh $SQL_WORK_FILE $SQLOUT_KK0241 $JOBNAME
# +++++++++++++++++++++++++++++++ v8.00.02 mod end +++++++++++++++++++++++++++++++
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($SQLOUT_KK0241 unload:rc=$rc) " 
    echo $JOBNAME " UNLOAD Error($SQLOUT_KK0241 unload:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

# ++++++++++++++ v10.00.01 mod start ++++++++++++
##--- TAI-2014-0000014 変更開始 ---
###KK0341
##sh ${G_TOOLSH}/EOKULD02.sh $SQLFILE_KK0341 $SQLOUT_KK0341 $JOBNAME
##KK0341 カレント取得
#EDIT_ULD_QUERY ${SQLFILE_KK0341} "${RSLT_OPEDATE}"
#sh ${G_TOOLSH}/EOKULD02.sh $SQL_WORK_FILE $SQLOUT_KK0341 $JOBNAME
##--- TAI-2014-0000014 変更終了 ---
#rc=$?
#if [ $rc -ne 0 ]
#then
#    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($SQLOUT_KK0341 unload:rc=$rc) " 
#    echo $JOBNAME " UNLOAD Error($SQLOUT_KK0341 unload:rc=$rc) "
#    exit ${G_RTN_ERROR}
#fi

# 統合アンロード（KK0341：カレント）取得
#  - SELECT(reconst)項目は以下
#      0 - 0.12   ：機器提供サービス契約番号
#      1 - 98.8   ：予約適用年月日
#      2 - 1.17   ：世代登録年月日時分秒
#      3 - 100.1  ：予約適用コード
#      4 - 161.1  ：無効フラグ
#      5 - 2.3    ：機器提供サービス契約ステータス
#      6 - 27.12  ：サービス契約回線内訳番号
#      7 - 3.4    ：機器提供サービスコード
#      8 - 110.8  ：サービス開始年月日
#      9 - 111.8  ：サービス課金開始年月日
#     10 - 25.10  ：サービス契約番号
#     11 - 102.8  ：プラン開始年月日
#     12 - 103.8  ：プラン終了年月日
#     13 - 104.8  ：プラン課金開始年月日
#     14 - 105.8  ：プラン課金終了年月日
#     15 - 13.2   ：宅内機器種別コード
#     16 - 15.20  ：機器製造番号
#     17 - 107.8  ：サービスキャンセル年月日
#     18 - 126.8  ：サービス解約年月日
#     19 - 141.1  ：ｅｏＴＶ機器設置承認状態コード
#     20 - 142.8  ：機器設置承認年月日
#     21 - 144.8  ：ＣＡＳカード使用許諾年月日
EDIT_ULD_QUERY ${SQLFILE_KK0341_COM} "${RSLT_OPEDATE}"
sh ${G_TOOLSH}/EOKULD02.sh $SQL_WORK_FILE $KK0341_COM_OTF $JOBNAME

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

# 統合アンロード(機器提供サービス契約-カレント)から必要な情報を抽出する
#  - SELECT(reconst)項目は以下
#      0 - 0.12   ：機器提供サービス契約番号
#      1 - 1.8    ：予約適用年月日
#      2 - 2.17   ：世代登録年月日時分秒
#      3 - 3.1    ：予約適用コード
#      4 - 4.1    ：無効フラグ
#      5 - 5.3    ：機器提供サービス契約ステータス
#      6 - 6.12   ：サービス契約回線内訳番号
#      7 - 7.4    ：機器提供サービスコード
#      8 - 8.8    ：サービス開始年月日
#      9 - 9.8    ：サービス課金開始年月日
#     10 - 10.10  ：サービス契約番号
gawk 'BEGIN {FS=",";OFS=","}
            {print $1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11}' ${KK0341_COM_OTF} > ${SQLOUT_KK0341}
# ++++++++++++++ v10.00.01 mod end ++++++++++++++


#--- TAI-2014-0000014 変更開始 ---
##KK2811
#sh ${G_TOOLSH}/EOKULD02.sh $SQLFILE_KK2811 $SQLOUT_KK2811 $JOBNAME
#KK2811 カレント取得
EDIT_ULD_QUERY ${SQLFILE_KK2811} "${RSLT_OPEDATE}"
sh ${G_TOOLSH}/EOKULD02.sh $SQL_WORK_FILE $SQLOUT_KK2811 $JOBNAME
#--- TAI-2014-0000014 変更終了 ---
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($SQLOUT_KK2811 unload:rc=$rc) " 
    echo $JOBNAME " UNLOAD Error($SQLOUT_KK2811 unload:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#KK2851
# ++++++++++++++ v8.00.02 mod start ++++++++++++++
#sh ${G_TOOLSH}/EOKULD02.sh $SQLFILE_KK2851 $SQLOUT_KK2851 $JOBNAME
EDIT_ULD_QUERY ${SQLFILE_KK2851} "${RSLT_OPEDATE}"
sh ${G_TOOLSH}/EOKULD02.sh $SQL_WORK_FILE $SQLOUT_KK2851 $JOBNAME
# ++++++++++++++ v8.00.02 mod end ++++++++++++++
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($SQLOUT_KK2851 unload:rc=$rc) " 
    echo $JOBNAME " UNLOAD Error($SQLOUT_KK2851 unload:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#KK0781
# ++++++++++++++ v8.00.02 mod start ++++++++++++++
#sh ${G_TOOLSH}/EOKULD02.sh $SQLFILE_KK0781 $SQLOUT_KK0781 $JOBNAME
#rc=$?
#if [ $rc -ne 0 ]
#then
#    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($SQLOUT_KK0781 unload:rc=$rc) " 
#    echo $JOBNAME " UNLOAD Error($SQLOUT_KK0781 unload:rc=$rc) "
#    exit ${G_RTN_ERROR}
#fi
EDIT_ULD_QUERY ${SQLFILE_KK0781} "${RSLT_OPEDATE}"
sh ${G_TOOLSH}/EOKULD02.sh $SQL_WORK_FILE $BSORTOUT_KK0781 $JOBNAME
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($BSORTOUT_KK0781 unload:rc=$rc) " 
    echo $JOBNAME " UNLOAD Error($BSORTOUT_KK0781 unload:rc=$rc) "
    exit ${G_RTN_ERROR}
fi
# ++++++++++++++ v8.00.02 mod end ++++++++++++++

#KK1471
# ++++++++++++++ v8.00.02 mod start ++++++++++++++
#sh ${G_TOOLSH}/EOKULD02.sh $SQLFILE_KK1471 $SQLOUT_KK1471 $JOBNAME
#rc=$?
#if [ $rc -ne 0 ]
#then
#    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($SQLOUT_KK1471 unload:rc=$rc) " 
#    echo $JOBNAME " UNLOAD Error($SQLOUT_KK1471 unload:rc=$rc) "
#    exit ${G_RTN_ERROR}
#fi
EDIT_ULD_QUERY ${SQLFILE_KK1471} "${RSLT_OPEDATE}"
sh ${G_TOOLSH}/EOKULD02.sh $SQL_WORK_FILE $BSORTOUT_KK1471 $JOBNAME
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($BSORTOUT_KK1471 unload:rc=$rc) " 
    echo $JOBNAME " UNLOAD Error($BSORTOUT_KK1471 unload:rc=$rc) "
    exit ${G_RTN_ERROR}
fi
# ++++++++++++++ v8.00.02 mod end ++++++++++++++

# ++++++++++++++ v9.00.00 add start ++++++++++++++
sh ${G_TOOLSH}/EOKULD02.sh $SQLFILE_KK2111 $SQLOUT_KK2111 $JOBNAME
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($SQLOUT_KK2111 unload:rc=$rc) " 
    echo $JOBNAME " UNLOAD Error($SQLOUT_KK2111 unload:rc=$rc) "
    exit ${G_RTN_ERROR}
fi
# ++++++++++++++ v9.00.00 add end ++++++++++++++

##bsortex処理
##KK1451.tmpの出力
# +++++++++++++++++++++++++ v8.00.02 del start +++++++++++++++++++++++++
#ソート
#bsortex \
#   -sort key=0.10asc,1.8asc \
#   -record recform=txtcsv \
#   -input file=${SQLOUT_KK1451} \
#        reclen=60 \
#        include="5.1asc.eq.'0',1.8asc.eq.'${OPD}'" \
#   -output file=${BSORT_KK1451}
#rc=$?
#if [ $rc -ne 0 ]
#then
#  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK1451 Sort Error($SVC sort:$rc) "
#  echo $JOBNAME " KK1451 Sort Error($SVC sort:$rc)"
#  exit ${G_RTN_ERROR}
#fi
##マージ
#bsortex \
#    -merge key=0.10asc \
#    -record recform=txtcsv \
#    -input file=${BSORT_KK1451} \
#         reclen=60 \
#    -summary suppress last \
#    -output file=${BSORTOUT_KK1451}
#if [ $rc -ne 0 ]
#then
#  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK1451 Merge Error($SVC merge:$rc)"
#  echo $JOBNAME " KK1451 Merge Error($SVC merge:$rc)"
#  exit ${G_RTN_ERROR}
#fi
# +++++++++++++++++++++++++ v8.00.02 del end +++++++++++++++++++++++++

#--- TAI-2014-0000014 削除開始 ---
###KK0081.tmpの出力
##ソート
#bsortex \
#   -sort key=0.10asc,1.8asc,2.17asc \
#   -record recform=txtcsv \
#   -input file=${SQLOUT_KK0081} \
#        reclen=110 \
#        include="1.8asc.le.'${OPD}',3.1asc.eq.'2',4.1asc.eq.'0'" \
#   -output file=${BSORT_KK0081}
#rc=$?
#if [ $rc -ne 0 ]
#then
#  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK0081 Sort Error($SVC sort:$rc) "
#  echo $JOBNAME " KK0081 Sort Error($SVC sort:$rc)"
#  exit ${G_RTN_ERROR}
#fi
##マージ
#bsortex \
#    -merge key=0.10asc \
#    -record recform=txtcsv \
#    -input file=${BSORT_KK0081} \
#         reclen=110 \
#    -summary suppress last \
#    -output file=${BSORTOUT_KK0081}
#    
#rc=$?
#if [ $rc -ne 0 ]
#then
#  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK0081 Merge Error($SVC merge:$rc)"
#  echo $JOBNAME " KK0081 Merge Error($SVC merge:$rc)"
#  exit ${G_RTN_ERROR}
#fi
#--- TAI-2014-0000014 削除終了 ---

##KK0241.tmpの出力
# +++++++++++++++++++++++++ v8.00.02 mod start +++++++++++++++++++++++++
#ソート
#bsortex \
#   -sort key=1.12asc,0.10asc,2.8asc \
#   -record recform=txtcsv \
#   -input file=${SQLOUT_KK0241} \
#        reclen=60 \
#        include="2.8asc.le.'${OPD}',3.8asc.ge.'${OPD}',4.1asc.eq.'0'" \
#   -output file=${BSORT_KK0241}
#rc=$?
#if [ $rc -ne 0 ]
#then
#  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK0241 Sort Error($SVC sort:$rc) "
#  echo $JOBNAME " KK0241 Sort Error($SVC sort:$rc)"
#  exit ${G_RTN_ERROR}
#fi
##マージ
#bsortex \
#    -merge key=1.12asc,0.10asc \
#    -record recform=txtcsv \
#    -input file=${BSORT_KK0241} \
#         reclen=60 \
#    -summary suppress last \
#    -output file=${BSORTOUT_KK0241}
#ソート
# OM-2015-0003006 性能改善対応 2015/11/18 有本 MOD START
#bsortex \
#    -sort key=1.12asc,0.10asc \
#    -record recform=txtcsv \
#    -input file=${SQLOUT_KK0241} \
#         reclen=60 \
#    -output file=${BSORTOUT_KK0241}
bsortex \
    -copy \
    -record recform=txtcsv \
    -input file=${SQLOUT_KK0241} \
         reclen=60 \
    -output file=${BSORTOUT_KK0241}
# OM-2015-0003006 性能改善対応 2015/11/18 有本 MOD END
rc=$?
# +++++++++++++++++++++++++ v8.00.02 mod end +++++++++++++++++++++++++
if [ $rc -ne 0 ]
then
  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK0241 Merge Error($SVC merge:$rc)"
  echo $JOBNAME " KK0241 Merge Error($SVC merge:$rc)"
  exit ${G_RTN_ERROR}
fi

#--- TAI-2014-0000014 削除開始 ---
###KK0341.tmpの出力
##ソート
#bsortex \
#   -sort key=0.12asc,1.8asc,2.17asc \
#   -record recform=txtcsv \
#   -input file=${SQLOUT_KK0341} \
#        reclen=110 \
#        include="1.8asc.le.'${OPD}',3.1asc.eq.'2',4.1asc.eq.'0'" \
#   -output file=${BSORT_KK0341}
#rc=$?
#if [ $rc -ne 0 ]
#then
#  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK0341 Sort Error($SVC sort:$rc) "
#  echo $JOBNAME " KK0341 Sort Error($SVC sort:$rc)"
#  exit ${G_RTN_ERROR}
#fi
##マージ
#bsortex \
#    -merge key=0.12asc \
#    -record recform=txtcsv \
#    -input file=${BSORT_KK0341} \
#         reclen=110 \
#    -summary suppress last \
#    -output file=${BSORTOUT_KK0341}
#    
#rc=$?
#if [ $rc -ne 0 ]
#then
#  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK0341 Merge Error($SVC merge:$rc)"
#  echo $JOBNAME " KK0341 Merge Error($SVC merge:$rc)"
#  exit ${G_RTN_ERROR}
#fi
#
###KK2811.tmpの出力
##ソート
#bsortex \
#   -sort key=0.12asc,1.8asc,2.17asc \
#   -record recform=txtcsv \
#   -input file=${SQLOUT_KK2811} \
#        reclen=90 \
#        include="1.8asc.le.'${OPD}',3.1asc.eq.'2',4.1asc.eq.'0'" \
#   -output file=${BSORT_KK2811}
#rc=$?
#if [ $rc -ne 0 ]
#then
#  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK2811 Sort Error($SVC sort:$rc) "
#  echo $JOBNAME " KK2811 Sort Error($SVC sort:$rc)"
#  exit ${G_RTN_ERROR}
#fi
##マージ
#bsortex \
#    -merge key=0.12asc \
#    -record recform=txtcsv \
#    -input file=${BSORT_KK2811} \
#         reclen=90 \
#    -summary suppress last \
#    -output file=${BSORTOUT_KK2811}
#    
#rc=$?
#if [ $rc -ne 0 ]
#then
#  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK2811 Merge Error($SVC merge:$rc)"
#  echo $JOBNAME " KK2811 Merge Error($SVC merge:$rc)"
#  exit ${G_RTN_ERROR}
#fi
#--- TAI-2014-0000014 削除終了 ---

##KK2851.tmpの出力
# +++++++++++++++++++++++++ v8.00.02 mod start +++++++++++++++++++++++++
##ソート
#bsortex \
#   -sort key=0.2asc,4.3asc,1.8asc \
#   -record recform=txtcsv \
#   -input file=${SQLOUT_KK2851} \
#        reclen=40 \
#        include="1.8asc.le.'${OPD}',2.8asc.ge.'${OPD}',3.1asc.eq.'0'" \
#   -output file=${BSORT_KK2851}
#rc=$?
#if [ $rc -ne 0 ]
#then
#  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK2851 Sort Error($SVC sort:$rc) "
#  echo $JOBNAME " KK2851 Sort Error($SVC sort:$rc)"
#  exit ${G_RTN_ERROR}
#fi
##マージ
#bsortex \
#    -merge key=0.2asc,4.3asc \
#    -record recform=txtcsv \
#    -input file=${BSORT_KK2851} \
#         reclen=40 \
#    -summary suppress last \
#    -output file=${BSORTOUT_KK2851}
#ソート
bsortex \
    -merge key=0.2asc,4.3asc \
    -record recform=txtcsv \
    -input file=${SQLOUT_KK2851} \
         reclen=40 \
    -output file=${BSORTOUT_KK2851}
    
rc=$?
# +++++++++++++++++++++++++ v8.00.02 mod end +++++++++++++++++++++++++
if [ $rc -ne 0 ]
then
  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK2851 Merge Error($SVC merge:$rc)"
  echo $JOBNAME " KK2851 Merge Error($SVC merge:$rc)"
  exit ${G_RTN_ERROR}
fi

# +++++++++++++++++++++++++ v8.00.02 del start +++++++++++++++++++++++++
###KK0781.tmpの出力
##ソート
#bsortex \
#   -sort key=0.2asc,1.8asc,2.17asc \
#   -record recform=txtcsv \
#   -input file=${SQLOUT_KK0781} \
#        reclen=50 \
#        include="1.8asc.le.'${OPD}',3.1asc.eq.'0'" \
#   -output file=${BSORT_KK0781}
#rc=$?
#if [ $rc -ne 0 ]
#then
#  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK0781 Sort Error($SVC sort:$rc) "
#  echo $JOBNAME " KK0781 Sort Error($SVC sort:$rc)"
#  exit ${G_RTN_ERROR}
#fi
##マージ
#bsortex \
#    -merge key=0.2asc \
#    -record recform=txtcsv \
#    -input file=${BSORT_KK0781} \
#         reclen=50 \
#    -summary suppress last \
#    -output file=${BSORTOUT_KK0781}
#    
#rc=$?
#if [ $rc -ne 0 ]
#then
#  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK0781 Merge Error($SVC merge:$rc)"
#  echo $JOBNAME " KK0781 Merge Error($SVC merge:$rc)"
#  exit ${G_RTN_ERROR}
#fi
# +++++++++++++++++++++++++ v8.00.02 del end +++++++++++++++++++++++++

# +++++++++++++++++++++++++ v8.00.02 del start +++++++++++++++++++++++++
###KK1471.tmpの出力
##ソート
#bsortex \
#   -sort key=0.10asc,3.12asc \
#   -record recform=txtcsv \
#   -input file=${SQLOUT_KK1471} \
#        reclen=80 \
#        include="6.1asc.eq.'0',2.8asc.eq.'${OPD}'" \
#   -output file=${BSORT_KK1471}
#rc=$?
#if [ $rc -ne 0 ]
#then
#  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK1471 Sort Error($SVC sort:$rc) "
#  echo $JOBNAME " KK1471 Sort Error($SVC sort:$rc)"
#  exit ${G_RTN_ERROR}
#fi
##マージ
#bsortex \
#    -merge key=0.10asc \
#    -record recform=txtcsv \
#    -input file=${BSORT_KK1471} \
#         reclen=80 \
#    -summary suppress last \
#    -output file=${BSORTOUT_KK1471}
#    
#rc=$?
#if [ $rc -ne 0 ]
#then
#  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KK1471 Merge Error($SVC merge:$rc)"
#  echo $JOBNAME " KK1471 Merge Error($SVC merge:$rc)"
#  exit ${G_RTN_ERROR}
#fi
# +++++++++++++++++++++++++ v8.00.02 del end +++++++++++++++++++++++++

##KKIFM569001.csvの作成
#--- マッチング処理
#      p1：出力ファイルパス
#      p2：DEFファイルパス
#      p3：TMPDEFファイルパス
EXEC_MATCHING ${OUTFILE_KKIFM569001} ${DEFFILE_KKIFM569001} ${TMPDEFFILE_KKIFM569001}

# ++++++++++++++ v10.00.00 add start ++++++++++++++
##KKIFM569009.csvの作成
#--- マッチング処理
#      p1：出力ファイルパス
#      p2：DEFファイルパス
#      p3：TMPDEFファイルパス
EXEC_MATCHING ${OUTFILE_KKIFM569009} ${DEFFILE_KKIFM569009} ${TMPDEFFILE_KKIFM569009}

#「工事遅延契約補正(多機能ルーター)」対象に「工事遅延契約補正(タブレット)」対象を追加
#KKIFM569001.csvにKKIFM569009.csvの中身を追加する
cat ${OUTFILE_KKIFM569009} >> ${OUTFILE_KKIFM569001}
# ++++++++++++++ v10.00.00 add end ++++++++++++++

##KKIFM569005.csvの作成
#--- マッチング処理
#      p1：出力ファイルパス
#      p2：DEFファイルパス
#      p3：TMPDEFファイルパス
EXEC_MATCHING ${OUTFILE_KKIFM569005} ${DEFFILE_KKIFM569006} ${TMPDEFFILE_KKIFM569006}

# ++++++++++++++ v10.00.00 add start ++++++++++++++
##KKIFM569010.csvの作成
#--- マッチング処理
#      p1：出力ファイルパス
#      p2：DEFファイルパス
#      p3：TMPDEFファイルパス
EXEC_MATCHING ${OUTFILE_KKIFM569010} ${DEFFILE_KKIFM569010} ${TMPDEFFILE_KKIFM569010}

#「工事完了取消(多機能ルーター)」対象に「工事完了取消(タブレット)」対象を追加
#KKIFM569005.csvにKKIFM569010.csvの中身を追加する
cat ${OUTFILE_KKIFM569010} >> ${OUTFILE_KKIFM569005}
# ++++++++++++++ v10.00.00 add end ++++++++++++++

#マージ
#KKIFM569005
# OM-2015-0003006 性能改善対応 2015/11/18 有本 MOD START
#bsortex \
#   -sort key=3.12asc \
#    -record recform=txtcsv \
#    -input file=${OUTFILE_KKIFM569005} \
#         reclen=90 \
#         include="(0.8asc.eq.'20991231').or.(1.8asc.eq.'20991231')" \
#    -output file=${MERGEFILE_KKIFM569005}
bsortex \
   -copy \
    -record recform=txtcsv \
    -input file=${OUTFILE_KKIFM569005} \
         reclen=90 \
         include="(0.8asc.eq.'20991231').or.(1.8asc.eq.'20991231')" \
    -output file=${MERGEFILE_KKIFM569005}
# OM-2015-0003006 性能改善対応 2015/11/18 有本 MOD END
    
rc=$?
if [ $rc -ne 0 ]
then
  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KKIFM569005 Merge Error($SVC merge:$rc)"
  echo $JOBNAME " KKIFM569005 Merge Error($SVC merge:$rc)"
  exit ${G_RTN_ERROR}
fi

#「工事遅延契約補正」対象に「工事完了取消」対象を追加
#KKIFM569001.csvにKKIFM569005_MERGE.csvの中身を追加する
cat ${MERGEFILE_KKIFM569005} >> ${OUTFILE_KKIFM569001}

##KKIFM569006_001.csvの作成
#--- マッチング処理
#      p1：出力ファイルパス
#      p2：DEFファイルパス
#      p3：TMPDEFファイルパス
EXEC_MATCHING ${OUTFILE_KKIFM569006} ${DEFFILE_KKIFM569007} ${TMPDEFFILE_KKIFM569007}

#ソート
bsortex \
   -sort key=3.12asc \
   -record recform=txtcsv \
   -input file=${OUTFILE_KKIFM569006} \
        reclen=90 \
   -output file=${BSORTOUT_KKIFM569006}
rc=$?
if [ $rc -ne 0 ]
then
  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KKIFM569006_001 Sort Error($SVC sort:$rc) "
  echo $JOBNAME " KKIFM569006_001 Sort Error($SVC sort:$rc)"
  exit ${G_RTN_ERROR}
fi
#マージ
#KKIFM569006_001
bsortex \
    -merge key=3.12asc \
    -record recform=txtcsv \
    -input file=${BSORTOUT_KKIFM569006} \
         reclen=90 \
    -summary suppress last \
    -output file=${MERGEFILE_KKIFM569006}
    
rc=$?
if [ $rc -ne 0 ]
then
  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KKIFM569006_001 Merge Error($SVC merge:$rc)"
  echo $JOBNAME " KKIFM569006_001 Merge Error($SVC merge:$rc)"
  exit ${G_RTN_ERROR}
fi

#「工事遅延契約補正」対象に「機器オプションサービス契約（VA）」対象を追加
#KKIFM569001.csvにKKIFM569006_MERGE.csvの中身を追加する
cat ${MERGEFILE_KKIFM569006} >> ${OUTFILE_KKIFM569001}

#ソート
#KKIFM569001
bsortex \
   -sort key=3.12asc,0.8asc,1.8asc \
   -record recform=txtcsv \
   -input file=${OUTFILE_KKIFM569001} \
        reclen=90 \
   -output file=${BSORTOUT_KKIFM569001}
rc=$?
if [ $rc -ne 0 ]
then
  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KKIFM569001 Sort Error($SVC sort:$rc) "
  echo $JOBNAME " KKIFM569001 Sort Error($SVC sort:$rc)"
  exit ${G_RTN_ERROR}
fi

#マージ
#KKIFM569001
bsortex \
    -merge key=3.12asc \
    -record recform=txtcsv \
    -input file=${BSORTOUT_KKIFM569001} \
         reclen=90 \
    -summary suppress last \
    -output file=${MERGEFILE_KKIFM569001}
    
rc=$?
if [ $rc -ne 0 ]
then
  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KKIFM569001 Merge Error($SVC merge:$rc)"
  echo $JOBNAME " KKIFM569001 Merge Error($SVC merge:$rc)"
  exit ${G_RTN_ERROR}
fi

##KKIFM569002.csvの作成
#--- マッチング処理
#      p1：出力ファイルパス
#      p2：DEFファイルパス
#      p3：TMPDEFファイルパス
EXEC_MATCHING ${OUTFILE_KKIFM569002} ${DEFFILE_KKIFM569002} ${TMPDEFFILE_KKIFM569002}

#ソート
#KKIFM569002
bsortex \
   -sort key=0.12asc,1.10asc,2.17asc \
   -record recform=txtcsv \
   -input file=${OUTFILE_KKIFM569002} \
        reclen=50 \
   -output file=${BSORTOUT_KKIFM569002}
rc=$?
if [ $rc -ne 0 ]
then
  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KKIFM569002 Sort Error($SVC sort:$rc) "
  echo $JOBNAME " KKIFM569002 Sort Error($SVC sort:$rc)"
  exit ${G_RTN_ERROR}
fi

#マージ
#KKIFM569002
bsortex \
    -merge key=0.12asc,1.10asc \
    -record recform=txtcsv \
    -input file=${BSORTOUT_KKIFM569002} \
         reclen=50 \
    -summary suppress last \
    -output file=${MERGEFILE_KKIFM569002}
    
rc=$?
if [ $rc -ne 0 ]
then
  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KKIFM569002 Merge Error($SVC merge:$rc)"
  echo $JOBNAME " KKIFM569002 Merge Error($SVC merge:$rc)"
  exit ${G_RTN_ERROR}
fi

##KKIFM569003.csvの作成
#--- マッチング処理
#      p1：出力ファイルパス
#      p2：DEFファイルパス
#      p3：TMPDEFファイルパス
EXEC_MATCHING ${OUTFILE_KKIFM569003} ${DEFFILE_KKIFM569003} ${TMPDEFFILE_KKIFM569003}

#ソート
#KKIFM569003
bsortex \
   -sort key=0.12asc,1.10asc,2.17asc \
   -record recform=txtcsv \
   -input file=${OUTFILE_KKIFM569003} \
        reclen=50 \
   -output file=${BSORTOUT_KKIFM569003}
rc=$?
if [ $rc -ne 0 ]
then
  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KKIFM569003 Sort Error($SVC sort:$rc) "
  echo $JOBNAME " KKIFM569003 Sort Error($SVC sort:$rc)"
  exit ${G_RTN_ERROR}
fi

#マージ
#KKIFM569003
bsortex \
    -merge key=0.12asc,1.10asc \
    -record recform=txtcsv \
    -input file=${BSORTOUT_KKIFM569003} \
         reclen=50 \
    -summary suppress last \
    -output file=${MERGEFILE_KKIFM569003}
    
rc=$?
if [ $rc -ne 0 ]
then
  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KKIFM569003 Merge Error($SVC merge:$rc)"
  echo $JOBNAME " KKIFM569003 Merge Error($SVC merge:$rc)"
  exit ${G_RTN_ERROR}
fi

##KKIFM569004.csvの作成
#--- マッチング処理
#      p1：出力ファイルパス
#      p2：DEFファイルパス
#      p3：TMPDEFファイルパス
EXEC_MATCHING ${OUTFILE_KKIFM569004} ${DEFFILE_KKIFM569004} ${TMPDEFFILE_KKIFM569004}

#ソート
#KKIFM569004
bsortex \
   -sort key=0.12asc,1.10asc,2.17asc \
   -record recform=txtcsv \
   -input file=${OUTFILE_KKIFM569004} \
        reclen=50 \
   -output file=${BSORTOUT_KKIFM569004}
rc=$?
if [ $rc -ne 0 ]
then
  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KKIFM569004 Sort Error($SVC sort:$rc) "
  echo $JOBNAME " KKIFM569004 Sort Error($SVC sort:$rc)"
  exit ${G_RTN_ERROR}
fi

#マージ
#KKIFM569004
bsortex \
    -merge key=0.12asc,1.10asc \
    -record recform=txtcsv \
    -input file=${BSORTOUT_KKIFM569004} \
         reclen=50 \
    -summary suppress last \
    -output file=${MERGEFILE_KKIFM569004}
    
rc=$?
if [ $rc -ne 0 ]
then
  sh ${G_TOOLSH}/EOK010210J0.sh JOBNAME " KKIFM569004 Merge Error($SVC merge:$rc)"
  echo $JOBNAME " KKIFM569004 Merge Error($SVC merge:$rc)"
  exit ${G_RTN_ERROR}
fi

##KKIFM569.csvの作成
#--- マッチング処理
#      p1：出力ファイルパス
#      p2：DEFファイルパス
#      p3：TMPDEFファイルパス
# ++++++++++++++ v9.00.00 mod start ++++++++++++++
#EXEC_MATCHING ${OUTFILE_KKIFM569} ${DEFFILE_KKIFM569005} ${TMPDEFFILE_KKIFM569005}
EXEC_MATCHING ${OUTFILE_KKIFM569008} ${DEFFILE_KKIFM569005} ${TMPDEFFILE_KKIFM569005}
# ++++++++++++++ v9.00.00 mod end ++++++++++++++

# ++++++++++++++ v9.00.00 add start ++++++++++++++
##KKIFM569.csvの作成
#--- マッチング処理
#      p1：出力ファイルパス
#      p2：DEFファイルパス
#      p3：TMPDEFファイルパス
EXEC_MATCHING ${OUTFILE_KKIFM569} ${DEFFILE_KKIFM569008} ${TMPDEFFILE_KKIFM569008}
# ++++++++++++++ v9.00.00 add end ++++++++++++++

# ++++++++++++++ v8.00.01 mod start ++++++++++++++
# 当ジョブで利用していたワークファイルを削除する。
rm -f ${SQLOUT_KK0081}
rm -f ${SQLOUT_KK0241}
rm -f ${SQLOUT_KK0341}
rm -f ${SQLOUT_KK2811}
rm -f ${SQLOUT_KK2851}
rm -f ${BSORTOUT_KK1451}
rm -f ${BSORTOUT_KK0241}
rm -f ${BSORTOUT_KK2851}
rm -f ${BSORTOUT_KK0781}
rm -f ${BSORTOUT_KK1471}
rm -f ${BSORTOUT_KKIFM569001}
rm -f ${BSORTOUT_KKIFM569002}
rm -f ${BSORTOUT_KKIFM569003}
rm -f ${BSORTOUT_KKIFM569004}
rm -f ${BSORTOUT_KKIFM569006}
rm -f ${MERGEFILE_KKIFM569001}
rm -f ${MERGEFILE_KKIFM569002}
rm -f ${MERGEFILE_KKIFM569003}
rm -f ${MERGEFILE_KKIFM569004}
rm -f ${MERGEFILE_KKIFM569005}
rm -f ${MERGEFILE_KKIFM569006}
rm -f ${OUTFILE_KKIFM569001}
rm -f ${OUTFILE_KKIFM569002}
rm -f ${OUTFILE_KKIFM569003}
rm -f ${OUTFILE_KKIFM569004}
rm -f ${OUTFILE_KKIFM569005}
rm -f ${OUTFILE_KKIFM569006}
# ++++++++++++++ v8.00.01 mod end ++++++++++++++
# ++++++++++++++ v9.00.00 add start ++++++++++++++
rm -f ${SQLOUT_KK2111}
rm -f ${TMPDEFFILE_KKIFM569008}
rm -f ${OUTFILE_KKIFM569008}
# ++++++++++++++ v9.00.00 add end ++++++++++++++
# ++++++++++++++ v10.00.00 add start ++++++++++++++
rm -f ${TMPDEFFILE_KKIFM569009}
rm -f ${TMPDEFFILE_KKIFM569010}
rm -f ${OUTFILE_KKIFM569009}
rm -f ${OUTFILE_KKIFM569010}
# ++++++++++++++ v10.00.00 add end ++++++++++++++

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

exit ${G_RTN_NORMAL}