I have a process that spits out a file called sqlplus.out, here is what the result looks like:
Currently the value you see is zero, what I need to do is perform an action if that value is non-zero, so how do I check that value in an if statement? If it helps at this moment in development the line with the value will always be on line 4.

Thanks for the help!

You can do it simpler, but I am assuming that you might have several things to do when a non-zero is found.
This is looking for the last one line of the file; knowing that the value will be on that line.


x=$(tail -1 sqlplus.out)

echo $x
if [ $x -ne 0 ]
then
echo "You have found a non-zero value"
fi

Won't run in bourne, for a bourne-safe syntax, use back ticks:

if [ `tail -1 sqlplus.out` -ne 0 ] ; then echo "You have found a non-zero value" ; fi

without the back ticks it didn't work, so thanks go to the Smiling Dragon for helping out and thanks joeyg for the attempt. However, it still doesn't work, I get the following as a result:

" near 0wn operator in arithmetic expression "0

just a side note what DB are using to get the data out of?
I know if you use certain operaters in DB2 you can cut out all the unneeded stuff like column headers I.E.

db2 -x "select * from your.table"

Ah, in that case, we can make the search for 0 on the last line a little more robust, the following will trigger if you get a non-zero exit code but will ignore any non-digit characters on the line. You could add a second grep for a 0 afterwards to confirm it's given an exit code at all but I've left that off in the example below:

if `tail -1 sqlplus.out | egrep '[1-9]'` ; then ...

Thanks!

While I am sure your solution works perfectly, I was able to work around the problem by changing my SQL that produces the difference between last id and max id and output 'true' if there is a difference. Now I just need to grep on true from the sqlplus.out file and that satisfies the condition.

As always unix.com delivers, in my case not a final solution, but helpful hints to get me there.