Shell Programming and Scripting

Hi

My source database is seibel and the target is oracle. I need to check the count for source query and target query. if it is equal then i need to send and success mail to an email id. If it is not equal need to send an failure mail to an email id.

pl let me know about the script in ksh.

Thanks
Babu

In rough terms...

scnt=$(execute command to learn source count)
tcnt=$(execute command to learn target count)

if [ $scnt -eq $tcnt ]
then
mailx -s "files match" good@myco.com
else
mailx -s "files do not match" bad@myco.com
fi

Thanks Joeyg.

Select count(*) Tbl -- Src table

count(*)
---------
10

select count(*) from tbl --target table

count(*)
---------
10

i write the src and tgt out put to src_count.out and tgt_count.out

#!/bin/ksh

SUBJECT=`echo "COUNT MATCHING"`
SUBJECT1=`echo "COUNT NOT MATCHING"`
RECIPIENT=abc@abc.com
cd /babu
src_cnt=`cat src_count.out | tail -1`
tgt_cnt=`cat tgt_count.out | tail -1`

if [ $src_cnt -eq $tgt_cnt ]
then
echo "Source Count $src_cnt \nTarget Count $tgt_cnt" | mailx -s "$SUBJECT" $RECIPIENT
exit 1
else
echo "Source Count $src_cnt \nTarget Count $tgt_cnt" | mailx -s "$SUBJECT1" $RECIPIENT
exit 0
fi

The above code works fine..

One more points i need to have.... As i told my source is seibel and Target is oracle
how i will connect to the database through shell script..

As of now i just created two files /path/src_count.out and /path/tgt_count.out and put the count as
count(*)
--------
10

for target
count(*)
-------
10
and save the two files and processed the output.

But pl let me know how to connect to DB connect string thro shell script

Thanks
Babu