Shell Programming and Scripting

  
 while read i; do
  DB_Name=$i
  awk '{for(i=1;i<=NF;i++)if($i~/$DB_Name/)print $(i)}' $BTEQ_NAME > $DB_Name_TableList.txt
  done <Param.txt

  
 ODS_TARGT_RECV
FIN_TARGT
ODS_TARGT
ODS_REP
ODS_REP_SRCE
ODS_ARCV
EDW_TARGT
EDW_REP
EDW_DATA
EDW_REP_SRCE
edw_etl_target
edw_archive
WEB_TARGT
edw_archive
WEB_DRG1_APP_SRCE

  
 #Script Name : DB_Validation.sh
#Author : Shilpi Gupta
 clear
 DB_FIND()
 {
  IFS=$'\n' 
  set -f
  echo "=================$BTEQ_NAME=================="
  while read i; do
  DB_Name=$i
  awk '{for(i=1;i<=NF;i++)if($i~/$DB_Name/)print $(i)}' $BTEQ_NAME > $DB_Name_TableList.txt
  done <Param.txt
 
  
}
  
 # Main Body of this Script
 BTEQ_NAME_LIST=$1
BTEQ_PARAM_FILE=$2
 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
 awk '{for(i=1;i<=NF;i++)if($i~/\=/)print $(i)}' $BTEQ_PARAM_FILE|cut -d"=" -f2 > ParamVal1.txt
 awk '{for(i=1;i<=NF;i++)if($i~/_/)print $(i)}' ParamVal1.txt > ParamVal.txt
 rm ParamVal1.txt
 for i in `cat ${BTEQ_NAME_LIST}` ; do
BTEQ_NAME=`echo "${i}" | awk -F"|" '{ print $1 }'`;
export BTEQ_NAME;
 DB_FIND
done

  
 awk: can't open BTQ_OAP_700_dI_OSTG_AP_INVC_FS.sh
 :
 :

  
 awk '{for(i=1;i<=NF;i++)if($i~/$DB_Name/)print $(i)}' $BTEQ_NAME > ${DB_Name}_TableList.txt

  
 
 awk '{for(i=1;i<=NF;i++)if($i~/\$ODS_REP_SRCE/)print $(i)}' BTQ_OAP_700_dI_OSTG_AP_INVC_FS.sh > ODS_REP_SRCE_TableList.txt

 awk '{for(i=1;i<=NF;i++)if($i~/$DB_Name/)print $(i)}' $BTEQ_NAME > ${DB_Name}_TableList.txt

awk -v target=$DB_Name '{for(i=1;i<=NF;i++)if($i ~ target)print $(i)}' $BTEQ_NAME > ${DB_Name}_TableList.txt

  
 awk: syntax error near line 1
awk: bailing out near line 1