UNIX for Dummies Questions & Answers

bcp_in() {
#echo  -e "\n\n\t\tbcp in $_currdate"

  echo -e 
  echo -e "BCP: $_currdate input file information into logfile table...\n"

  cat <<-endOfCat | bcp ${_DBName}..logfile in ${_currdate} -f$P/format/logfile.fmt -Q  -U$_UserId -P$_Password
  endOfCat

  if [ $? -ne 0 ]
  then
    echo -e "\n\n\t\tError in BCP. Verify the command"
   # delete_tables       
   # abort_message
  fi
}


bcp_out() {
#echo  -e "\n\n\t\tbcp out for file $_currdate"

echo -e "\n\n\t\tbcp out for file $_errfile"
}

#main

#Check for minumum number of arguments 
#
if [ $# -ne 4 ]
then
  print_version
  echo -e "\nUsage:" ${PROG}" THIS JOB IS TO BE RUN AS AUTOSYS JOB.PLEASE READ THE JOB DOCUMENT  \n"
  exit 1
fi
# Move the parameters into variables
_DBName=$1
_UserId=$2
_javadebug=`echo -e $JAVA_DEBUG`
export JAVA_DEBUG=0
_EncryptedPassword=$3
_Password=`$P_HOME/bin/jrun.ksh`
export JAVA_DEBUG=_javadebug
_indicator=$4
_ProcessId=$$


if [ $_indicator -eq 1 ]
then    
   _day1="$(date '+%a')"
   _day2="Tue"

   if [ $_day1 == $_day2 ]
   then
      echo "processing the file for 2 days before"
      _prev2date="log$(date -d "2 days ago" +"%y%j")"
      

      _currdate=$P/receiver/$_prev2date
      _logfile_name=$_prev2date
      _errfile=$PANEL_OUTPUTFILE_PATH/$_prev2date"_err"
     
_vercor_prev2date="vercor_$(date -d "2 days ago" +"%y%j")_001.txt"
      _ver_prev2date="ver_$(date -d "2 days ago" +"%y%j")_001.txt"
      
      _vercor_currdate=$P/receiver/$_vercor_prev2date
      _ver_currdate=$P/receiver/$_ver_prev2date

     # process_ver_file 
      process_input_file

      echo  "processing the file for previous_day"
      _prev1date="log$(date -d "yesterday" +"%y%j")"
      _currdate=$P/receiver/$_prev1date
      _logfile_name=$_prev1date
      _errfile=$PANEL_OUTPUTFILE_PATH/$_prev1date"_err"
      
      _vercor_prev1date="vercor_$(date -d "yesterday" +"%y%j")_001.txt"
      _ver_prev1date="ver_$(date -d "yesterday" +"%y%j")_001.txt"
            
      _vercor_currdate=$P/receiver/$_vercor_prev1date
      _ver_currdate=$P/receiver/$_ver_prev1date
      
      #process_ver_file
      process_input_file

      echo "processing the file for current_day"
     _currdate=$P/receiver/"log$(date '+%y%j')"
     _logfile_name="log$(date '+%y%j')"
     _errfile=$PANEL_OUTPUTFILE_PATH/"log$(date '+%y%j')_err"

     _vercor_currdate=$P/receiver/"vercor_$(date '+%y%j')_001.txt"
     _ver_currdate=$P/receiver/"ver_$(date '+%y%j')_001.txt"

#      process_ver_file
      process_input_file
   else
     echo processing the file for current_day
     _currdate=$P/receiver/"log$(date '+%y%j')"
     _errfile=$PANEL_OUTPUTFILE_PATH/"log$(date '+%y%j')_err"

     _vercor_currdate=$P/receiver/"vercor_$(date '+%y%j')_001.txt"
      _ver_currdate=$P/receiver/"ver_$(date '+%y%j')_001.txt"


     process_input_file
   fi

else
     echo processing the file for current_day
     _currdate=$P/receiver/"log$(date '+%y%j')"
     _errfile=$PANEL_OUTPUTFILE_PATH/"log$(date '+%y%j')_err"

     _vercor_currdate=$P/receiver/"vercor_$(date '+%y%j')_001.txt"
      _ver_currdate=$P/receiver/"ver_$(date '+%y%j')_001.txt"


     process_input_file
fi

# Display the success message
success_message

exit 0