nested loop


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting nested loop
# 1  
nested loop

I have two do loops. When I break of the inner loop it doesn't go back to the outer loop but exit the program.
# 2  
Please post your code. Also, post which shell and OS you are using.
# 3  
Korn shell on a HP but the code will also run on AIX.
The code is very big but here is the piece that is not working

Code:
if [ "${ALERT}" ]
then
  set -x
  desc="performing maintenance on the Oracle alerts logs."
  echo "\n${desc}\n" >> ${logfile}

  export dblist=$(grep -v "#" ${oratab} | awk -F: '{print $1}')
  echo "${dblist}" | while read db
  do
    while true
    do
      export sid=${db}
      alertlog="alert_${sid}.log"
      echo "\nprocessing ${alertlog}." >> ${logfile}
      orauser=${admin}/${sid}/.orauser_${sid}
      if test ! -r "${orauser}"
      then
        errmsg=${main}.${today}.msg
        echo "unable to read ${orauser}" > ${errmsg}
        send_message ${maillist} ${errmsg}
        echo "\nunable to read ${orauser}." >> ${logfile}
        break
      fi
      . ${admin}/${sid}/.orauser_${sid}
      echo "\nsql query for background_dump_desc from ${sid}." >> ${logfile}
      sqlcmd=${workdir}/${main}.alertlog.${today}.sql
      sqllog=${workdir}/${main}.alertlog.${today}.log
      rm -f ${sqlcmd} ${sqllog}
      echo "set termout off" > ${sqlcmd}
      echo "set pagesize 0" >> ${sqlcmd}
      echo "set linesize 1024" >> ${sqlcmd}
      echo "set trimspool on" >> ${sqlcmd}
      echo "set heading off" >> ${sqlcmd}
      echo "set feedback off" >> ${sqlcmd}
      echo "set verify off" >> ${sqlcmd}
      echo "whenever sqlerror warning" >> ${sqlcmd}
      echo "spool ${sqllog}" >> ${sqlcmd}
      echo "select value from v\$parameter" >> ${sqlcmd}
      echo "  where name = 'background_dump_dest';" >> ${sqlcmd}
      echo "exit" >> ${sqlcmd}
      systempwd=$(get_pwd ${node} ${sid} system)
      (sqlplus -S system/${systempwd} @${sqlcmd}) >> ${logfile}
      if [ "${status}" -ne 0 ]
      then
        errmsg=${main}.${today}.msg
        echo "error ${status} retriving background_dump_dest \c" >> ${logfile}
        echo "from ${sid}." > ${errmsg}
        send_message ${maillist} ${errmsg}
        echo "error ${status} retriving background_dump_dest \c" >> ${logfile}
        echo "from ${sid}." >> ${logfile}
        break
      fi
      bdump=$(cat ${sqllog})
      echo "\nsqlplus query successful. bdump = ${bdump}\n" >> ${logfile}
      rm -f ${sqlcmd} ${sqllog}
      timestamp=$(gettimestamp)
      archive="${alertlog}.${timestamp}"
      cp -fp ${bdump}/${alertlog} ${bdump}/${archive}
      echo "\narchiving ${alertlog} to TSM." >> ${logfile}
      archive_file ${bdump} ${archive} ${mca}
      status=$?
      if [ "${status}" -ne 0 ]
      then
        errmsg=${main}.${today}.msg
        echo "error ${status} archiving ${archive} to TSM." > ${errmsg}
        send_message ${maillist} ${errmsg}
        echo "error ${status} archiving ${archive} to TSM." >> ${logfile}
        echo "restoring ${alertlog} to original state." >> ${logfile}
        tmpfile=${workdir}/${main}.tmp
          
        cmd="cat ${bdump}/${archive} ${bdump}/${alertlog} > ${tmpfile}; "
        cmd="${cmd} mv -f ${tmpfile} ${bdump}/${alertlog}; "
        cmd="rm -f ${bdump}/${archive} ${tmpfile}"
        (${cmd})
        break
      fi
      rm -f ${bdump}/${archive}
      echo "\ntruncating file ${bdump}/${alertlog}" >> ${logfile}
      truncate_file ${bdump}/${alertlog}
      status=$?
      if [ "${status}" -ne 0 ]
      then
        errmsg=${main}.${today}.msg
        echo "error ${status} truncating ${bdump}\c" > ${errmsg}
        echo "/${alertlog}." >> ${errmsg}
        send_message ${maillist} ${errmsg}
        echo "error ${status} truncating ${bdump}/\c" >> ${logfile}
        echo "${alertlog}." >> ${logfile}
        continue
      fi
      echo "\nfile truncated successfully.\n" >> ${logfile}
      break
    done
  done
fi

# 4  
I would like to see printing dblist after the following line
to see what it is printing and whether dblist is just a single line.

Code:
 export dblist=$(grep -v "#" ${oratab} | awk -F: '{print $1}')


Also print some log between those 2 'done' statements and see whether it is printed or not.



done
done
# 5  
Quote:
Originally Posted by bhargav
export dblist=$(grep -v "#" ${oratab} | awk -F: '{print $1}')
Code:
export dblist=$(awk -F: '/^[^#].*/ {print $1}' ${oratab})

# 6  
Thank you for all your help I change the command line and work fine. I don't now how this work but if you can explain to me why this command works and not the original one will be helpfull. Thank you again
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #648
Difficulty: Medium
Window Maker was written from scratch by Tim Berners-Lee, best known as the inventor of the World Wide Web.
True or False?

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Nested loop -bash

I am using the following nested loop for i in {1..3} do for y in {1..3} do if ; then echo P0${i}R${y}.fas mv P0${i}R${y}.fas P${i}R${y}.fas read -t 5 fi done done I was wondering if I can use a character such as * or ? instead of my second variable y. I tried R in... (3 Replies)
Discussion started by: Xterra
3 Replies

2. Shell Programming and Scripting

Nested for loop not ending

Hi All, Need help on below script for g in `cat /home/sid.txt` do for h in `cat /home/dev.txt` do symmaskdb -sid $g -dev $h list assign |grep FA |head -1|awk '{print $2}' > tt1.txt done done cat /home/sid.txt ************** 123 235 456 (5 Replies)
Discussion started by: ranjancom2000
5 Replies

3. Shell Programming and Scripting

Nested if loop

Hi Team, I just want to check whether my nested if loop used is correct or not. if ] if ] export1 else export2 fi else if ] export3 else export4 fi fi Thanks Shiva (5 Replies)
Discussion started by: shivashankar_S
5 Replies

4. UNIX for Dummies Questions & Answers

Nested loop code

Greetings, Would anyone be able to tell me why this nested loop doesn't seem to work in any variation? for i in {1..8} do echo "i is "$i for j in {1..i} do echo "j is "$j done doneoutput is always along the lines of i is 1... (7 Replies)
Discussion started by: barnhillec
7 Replies

5. Shell Programming and Scripting

Nested for loop in bash

Hi, How to use values in one for loop to other for loop. say "$sf_rel" variable has values "2011/W2 2011/G2" I want to use these values in inner for loop to process properly. $branch variable has G2 and 6 What is happening is outer for loop $i has 2011/W2 it is entering into inner... (3 Replies)
Discussion started by: Anjan1
3 Replies

6. Shell Programming and Scripting

Nested loop in Unix

Hi, I have the following script which is two while loops, but it is working only for the Inner loop without going back to the outer loop. the aim of this script is to remove data files from memory after each five times for each setting of the rotate parameter #!/bin/csh set hdir =... (1 Reply)
Discussion started by: moon218
1 Replies

7. Shell Programming and Scripting

Nested Loop becomes slow

Hello I have some nested loop to display files and form menu item. The part of the code is below. I found that after runnining the script for a while the display becomes very slow. Does ksh shell provided any easy way to release variables, reinit, etc. while ];do script=0 ... (2 Replies)
Discussion started by: ekb
2 Replies

8. Shell Programming and Scripting

nested loop problem

Please see the following script. basic="a b c" advance="d e f" A="basic advance" for g in $A do echo $g done The result would be obviously basic advance I want to ask how can i get the following result using $A in for loop a b c (5 Replies)
Discussion started by: mmunir
5 Replies

9. Shell Programming and Scripting

Variable in While Loop Nested If

Hi all, I'm having problems with the setting a variable in a nested if statement. It doesn't seem to change even if it mets the 'if' condition. My script essentially looks for a user name from the output from a kerberos command. When I find the user name, I tried to change a variable and exit... (6 Replies)
Discussion started by: geass
6 Replies

Featured Tech Videos