Shell Programming and Scripting

while [ $i -lt ${#wfcomp[*]} ]
do
X=`sqlplus -s batch_user/batch_user@$FUSION_SID << EOF5
  set heading off
  SET FEEDBACK OFF
  SET PAGESIZE 0
  SET LINESIZE 900
  select count(*) from FusionHC_Result where (status not in ('Online', 'Running') and CC_ALIAS = '${wfcomp[$i]}');
EOF5`
if [ $X -gt 0 ]
then
NEED TO PUT SOMETHING HERE TO MAKE THE SCRIPT BELOW TO EXECUTE ONLY 3 TIMES

$FusionHC_DIR/WFStart.ksh -----> THIS SCRIPT REFERENCES THE MAIN  SCRIPT AGAIN.

fi
((i=i+1))
done

if [ $X -gt 0 ]
then
if [ -f ".$0.run" ] ; then
  # Get the run count
  RUN=$(<.$0.run)
  if [ $RUN -ne 3 ] ; then
    $((RUN=RUN+1))
    echo $RUN > .$0.run
  else
    # cleanup
    /bin/rm -f .$0.run
    exit 0;
  fi ;
else
  # for the first run only
  echo "1" > .$0.run
fi ;

$FusionHC_DIR/WFStart.ksh -----> THIS SCRIPT REFERENCES THE MAIN  SCRIPT AGAIN.

fi

#!/bin/ksh

thisFILE="$(whence ${0})"

FUSER='/usr/sbin/fuser'

echo 'running MASTER...'

typeset -i numProc=$(${FUSER} ${thisFILE} 2>/dev/null | nawk '{print NF}')

if [[ "${numProc}" -gt 3 ]]; then
   echo "Warning: no more than 3 instances of [${thisFILE}] - exiting!"
   exit 1
fi;

echo '   calling MASTER'
${thisFILE}
# $FusionHC_DIR/WFStart.ksh -----> THIS SCRIPT REFERENCES THE MAIN SCRIPT AGAIN.

while [ $i -lt ${#wfcomp[*]} ]
do
X=`sqlplus -s batch_user/batch_user@$FUSION_SID << EOF5
  set heading off
  SET FEEDBACK OFF
  SET PAGESIZE 0
  SET LINESIZE 900
  select count(*) from FusionHC_Result where (status not in ('Online', 'Running') and CC_ALIAS = '${wfcomp[$i]}');
EOF5`
if [ $X -gt 0 ]
then

$FusionHC_DIR/WFStart.ksh -----> THIS HAS TO BE EXECUTED ONLY 3 TIMES AND THIS SCRIPT REFERENCES THE MAIN  SCRIPT AGAIN.

fi
((i=i+1))
done

while [ $i -lt ${#wfcomp[*]} ]
do
X=`sqlplus -s batch_user/batch_user@$FUSION_SID << EOF5
  set heading off
  SET FEEDBACK OFF
  SET PAGESIZE 0
  SET LINESIZE 900
  select count(*) from FusionHC_Result where (status not in ('Online', 'Running') and CC_ALIAS = '${wfcomp[$i]}');
EOF5`
if [ $X -gt 0 ]
then

$FusionHC_DIR/WFStart.ksh -----> Flow should be transferred here maximum 3 times. THIS HAS TO BE EXECUTED ONLY 3 TIMES AND THIS SCRIPT REFERENCES THE MAIN  SCRIPT AGAIN.
fi
((i=i+1))
done