Shell Programming and Scripting

total_lines=`wc -l $1 | awk '{print $1}'`

grep -n "ORA-" $1 |cut -d: -f1 >> ora_occ.txt
grep -n "Targ[[:space:]]Rowid" $1 | cut -d: -f1 >> targ_occ.txt
grep -n '^)$' $1 | cut -d: -f1 >> bracket_occ.txt

nr_of_occ=`wc -l targ_occ.txt | awk '{print $1}'`

   while [ "$i" -le "$nr_of_occ" ]
   do

      ora_line_nr=`sed -n \`echo $i\`p ora_occ.txt`
      targ_line_nr=`sed -n \`echo $i\`p  targ_occ.txt`
      bracket_line_nr=`sed -n \`echo $i\`p bracket_occ.txt`

      sed -n "$ora_line_nr p" $1 > ora_error_detail.txt

      while read ora_line
      do

      done <ora_error_detail.txt


      sed -n "$rec_start,$rec_end p " $1 > data_block.txt

      sed -e 's/(.*):/=/' data_block.txt |awk '{ line =line $0"|"} END { print line}' >>out_file.txt

   done

                          Open for  Open for
File            Records       Read     Write
--------------- -------   --------  --------
Inputfile             ?       5004
ora_occ.txt        5000       5000
targ_occ.txt       5000       5000
bracket_occ.txt    5000       5000
ora_error_deatail     1       5000      5000
data_block.txt       46       5000      5000 
--------------- -------   --------  --------
Total                        30004     10000