1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
| if [ ! $# -eq 3 ];
then
echo $0 user password instance
exit 1
fi
ret=0
printf "Chargement Cpta generique sur %s\n" $3
timestamp=_`date +%Y%m%d_%H%M`
logFile=$(dirname $0)/../log/param_generique$timestamp.log
printf "preload_param_generique....."
sqlplus -s $1/$2@$3 @../sql/preload_param_generique.sql >> $logFile 2>&1
ret=$(($ret+$?))
if [[ ret -ne 0 ]] ;
then
echo " !! Erreur !!"
exit 1
else
echo " OK"
fi
./csv_loader.ksh -x $1 $2 $3 ../cpta/TPE_SC
ret=$(expr $ret + $?)
[[ ret -ne 0 ]] && exit 1
./csv_loader.ksh -x $1 $2 $3 ../cpta/TPE_SC_LAC
ret=$(expr $ret + $?)
[[ ret -ne 0 ]] -x && exit 1
./csv_loader.ksh -x $1 $2 $3 ../cpta/TPE_SC_PARAM
ret=$(expr $ret + $?)
[[ ret -ne 0 ]] && exit 1
./csv_loader.ksh -x $1 $2 $3 ../cpta/TPE_SC_LAC_PARAM
ret=$(expr $ret + $?)
[[ ret -ne 0 ]] && exit 1
./csv_loader.ksh -x $1 $2 $3 ../cpta/TPE_FCTE_CPT
ret=$(expr $ret + $?)
[[ ret -ne 0 ]] && exit 1
printf "postload_param_generique....."
sqlplus -s $1/$2@$3 @../sql/postload_param_generique.sql >> $logFile 2>&1
ret=$(expr $ret + $?)
if [[ ret -ne 0 ]] ;
then
echo " !! Erreur !!"
exit 1
else
echo " OK"
fi
exit $ret |