Shell Programming and Scripting

  
 echo 'unix command'
echo 'unix command'
bteq << EOF
.logon <systemid>/<userid>,<password>;
select current_timestamp;
.logoff;
.quit;
EOF
echo 'unix command 3'
echo 'unix command 4'
echo 'unix command 5'

./script: line 4: unexpected EOF while looking for matching `"'
./script: line 7: syntax error: unexpected end of file

  
 clear
 DB_FIND()
 {
  IFS=$'\n'
  set -f
  echo "=================$BTEQ_NAME=================="
  while read i; do
  DB_Name=$i
  /usr/xpg4/bin/awk -v target=$DB_Name '{for(i=1;i<=NF;i++)if($i ~ target) print $(i)}' $BTEQ_NAME  > ${DB_Name}_TableList.txt
  sed '/FOLDR/d' ${DB_Name}_TableList.txt > ${DB_Name}_IFile.txt
  /usr/xpg4/bin/awk '!x[$0]++' ${DB_Name}_IFile.txt > ${DB_Name}_File.txt
  rm ${DB_Name}_IFile.txt
  rm ${DB_Name}_TableList.txt
  if [ -s ${DB_Name}_File.txt ] ; then
     echo ${DB_Name}_File.txt
      conn_string=`ksh /apps/cronacle/tools/teradata/.otherdetails/.Info_4ETL.sh UID_ODS_CLP_DRG`
     export conn_string;
     bteq <<EOF
     .logon ${conn_string};
     .export report FILE = /ftp/SrcFiles/src/SSSS/sample.txt;
     .SET SEPARATOR '|'
     SELECT * FROM dbc.tables where tablename='AP_INVC_F_V';
     .logoff
     .quit;
     EOF
 
  fi;
   done <Param.txt
 
}
  
 # Main Body of this Script
BTEQ_NAME_LIST=$1
 
for i in `cat ${BTEQ_NAME_LIST}` ; do
BTEQ_NAME=`echo "${i}" | awk -F"|" '{ print $1 }'`;
export BTEQ_NAME;
 BTEQ_PARAM_FILE=`awk '{for(i=1;i<=NF;i++)if($i~/\/bin/)print $(i)}' $BTEQ_NAME|cut -d"/" -f8|cut -d";" -f1`
 awk '{for(i=1;i<=NF;i++)if($i~/\=/)print $(i)}' $BTEQ_PARAM_FILE|cut -d"=" -f1 > ParamP1.txt
 awk '{for(i=1;i<=NF;i++)if($i~/_/)print $(i)}' ParamP1.txt > Param.txt
 #rm ParamP1.txt
 DB_FIND
 #rm Param.txt
 done