UNIX for Dummies Questions & Answers

Hi,

I have a shell script in which I am calling a function from a different shell script. This functions executes the SQL and the results are stored in a log file.

If the result of the SQL is "no rows selected" then I need to exit the main shell script. My shell script is executing fine if the records are found. But I am unable to stop or exit the shell script if there are no records found.

I tried using the following step.. but it is not working.

echo $SQL_REPORT | grep 'no' >> /dev/null
if [ $? = 0 ]
then
echo "== Found" >> $LOGFILE_SCRIPT
else
echo "== Not Found" >> $LOGFILE_SCRIPT
fi

I am able to find it if I 'm using the following code.

VAR=`grep 'no' $SQL_REPORT | sed -e "s/ //g;s/[ ]*$//" | cut -c1-14`
if [ $VAR = 'norowsselected' ]
then
exit
fi

But u can't always expect the result as "no rows selected".

Hope I have made it clear.

Thanks
Shash

echo $SQL_REPORT | grep 'no' >> /dev/null
if [ $? -eq 0 ]
then
echo "== Found" >> $LOGFILE_SCRIPT
else
echo "== Not Found" >> $LOGFILE_SCRIPT
exit 0
fi

try this

Code:

if grep -is 'no rows selected' $logfile >/dev/null
then
echo "pattern found"
else
echo "not found"
fi

Thanks a lot ranj!! It worked.

But is there any way I can totally come out of the main script.
This exit is only coming out of the function and the loop in which the main shell script was calling the function.

I need to stop the main script at this point of time.

Did a work around by creating a flag file and then checking for its existence in the main script to exit completely.