#!/bin/sh
set SRVR="COMPL_PROD"
rm tblistOUT
for DEEBEE in compl commodity data_entry_db option_db
do
isql -w 512 -U stjohnb -P stjohnb -S $SRVR -o tblist_tmp <<SQL_END
use $DEEBEE
go
sp_help
go
SQL_END
grep "user table" tblist_tmp | cut -c1-31 | sed 's/\ //g' > tblist_$DEEBEE
echo Done creating tblist_$DEEBEE
###################################
for TAYBLE in `cat tblist_$DEEBEE`
do
#echo Now searching
for rules in DATABASE: $DEEBEE TABLE: $TAYBLE
isql -w 512 -U stjohnb -P stjohnb -S $COMPL_PROD -o tblist_tmp <<SQL_END
use $DEEBEE
go
sp_help $TAYBLE
go
SQL_END
cut -c`grep "Rule_name" tblist_tmp | sed 's/Rule_name.*$//' | wc -m`- tblist_tmp | grep -v
"^NULL" | grep "^[A-Za-z0-9]" | grep -v "Rule_name.*Identity" | sed 's/ *0 *$//' >
tblist_tmpRULES
for RULE in `cat tblist_tmpRULES`
do
echo $DEEBEE $TAYBLE $RULE
isql -U stjohnb -P stjohnb -S $SRVR -o getrule_tmpRULEStxt <<SQL_END
use $DEEBEE
go
sp_helptext $RULE
go
SQL_END
cat -n getrule_tmpRULEStxt \
| grep -v "^ *[0-9] " \
| grep -v "return status = 0" \
| grep -v "^ *[0-9]*[ ]*$" \
| sed 's/^ */\//' \
| sed 's/ /\//' \
| sed "s/^/${DEEBEE}\/${TAYBLE}\/${RULE}/" \
| sed 's/^[\ \ ]*//' \
| sed 's/\/[ ]*/\//g' >> tblistOUT
done
done
####################################
done
rm tblist_*
echo