#
# Name          : dbc_gen_report_set.shl
# Purpose       : Create the report set records for table {desct} with owner
#                 {desco} and fields listed in dbc_gen_triggers.lst.
# Revisions
# Date          Modified by     Reason
# 25-Jan-00     Stephen Rea     Added table name report set.
#
cat dbc_gen_triggers.lst | read -r desco desct
echo "all,audit,`echo $desct | tr '[A-Z]' '[a-z]'`" | read DBC_DEF; export DBC_DEF
cat dbc_gen_triggers.lst | while read -r desc1 desc2 desc3 desc4 desc5 desc6
do
  if [ "$desc1" != "$desco" -a "$desc2" != "$desct" ]
  then
    for descx in $desc2 $desc3 $desc4 $desc5 $desc6
    do
      if [ -n "$descx" ]
      then
        if [ `echo "  $descx" | grep -c CHAR` -eq 1 ] 
        then
          echo "delete from system.dbc_columns where dbc_field_name = '${desc1}';"
          echo "insert into system.dbc_columns values ('${desc1}','${DBC_DEF}');"
        elif [ `echo "  $descx" | grep -c NUMBER` -eq 1 ] 
        then
          echo "delete from system.dbc_columns where dbc_field_name = '${desc1}';"
          echo "insert into system.dbc_columns values ('${desc1}','${DBC_DEF}');"
        elif [ `echo "  $descx" | grep -c DATE` -eq 1 ] 
        then
          echo "delete from system.dbc_columns where dbc_field_name = '${desc1}';"
          echo "insert into system.dbc_columns values ('${desc1}','${DBC_DEF}');"
        fi
      fi
    done
  fi
done