UNIX for Dummies Questions & Answers

##### SET VARIABLES ##################

rundate=`date +%H%M%b%d%Y`
LOGFILE=/logs/NDM/RSLAUTO.$rundate
BAN_CONF_STATUS=/logs/NDM/BANSTSAUTO.$rundate.$$
BAN_DETAILS=/logs/NDM/BAN_NAME_AUTO.$rundate.$$
homedir=/usr/local/ifs/resell
unsentlogdir=/usr/local/ifs/resell/unsent/logs
rsllogdir=/usr/local/ifs/resell/logs
codelist="FTP NDM CD"
echo "This Log is for rundate=$rundate"  | tee -a $LOGFILE
echo "--------------------------------------------------"  | tee -a $LOGFILE
echo " " | tee -a $LOGFILE


  ************    Special Code following Database password encryption     ***********

  DBCODE=CUSTMC
  DBMKT=${new_market:-$MARKET}
  RUN_MODE=F

  . setmarket_sh $DBMKT

status=`sqlplus -s $OP_CONNECT_STRING@$OPERATIONAL_DB_NAME << !

        set head off
        set line 999
        set echo on
        set feed on

      select username, password, db_instance db_instance_node from dbconfig
      where db_connect_code=(select db_connect_code from jobdbconnect
      where job_name='$DBCODE' and market='$DBMKT' and run_mode='$RUN_MODE');
!`
echo $status

      echo $status | grep "no rows selected" > /dev/null 2>&1
      if [ $? -eq 0 ]
        then
          echo "You have specified a connect code that does not exists" | tee -a $LOGFILE
          exit 1
      fi

      echo $status | grep "ORA-" > /dev/null 2>&1
      if [ $? -eq 0 ]
        then
          echo "An oracle error has occurred when trying to get db connection from op db" | tee -a $LOGFILE
          echo "$CODE_RESULTS" | tee -a $LOGFILE
          exit 2

echo "$OP_CONNECT_STRING@$OPERATIONAL_DB_NAME"