Shell Programming and Scripting

awk -F'.' -v Q="'" '
   {
      schemas[$1]++;
      include[$2]++;
   }
   END {
      for (s in schemas) 
         schemas_list = schemas_list (schemas_list ? "," : "") s;
      for (i in include)
         include_list = include_list (include_list ? "," : "") Q i Q;
      print "SCHEMAS=" schemas_list;
      print "INCLUDE=TABLE:\"IN (" include_list ")\"";
   }
    ' infile

#!/bin/ksh

Input_File=$1
Temp_File=temp.txt
Output_File=output.txt
rm -f $Output_File 2> /dev/null

for list_of_users in `cut -d'.' -f1 $Input_File | sort | uniq`
do
        for table_name in `grep -x "^$list_of_users\..*" $Input_File |cut -d'.' -f2`
        do
                tables=$tables","$table_name
        done
        echo $list_of_users":"${tables#,} >> $Temp_File
        tables=""
done
for list_of_objects in `cut -d':' -f2 $Temp_File | sort | uniq`
do
        for user_name in `grep -x "..*$list_of_objects\$" $Temp_File |cut -d':' -f1`
        do
                cmbuser=$cmbuser","$user_name
        done
        echo ${cmbuser#,}":"$list_of_objects >> $Output_File
        cmbuser=""
done
mv $Output_File $Temp_File
for line in `cat $Temp_File`
do
        echo $line | cut -d':' -f1 | read user_list
        echo $line | cut -d':' -f2 | read table_list
        echo "SCHEMAS=$user_list" >> $Output_File
        echo 'INCLUDE=TABLE:"IN('$table_list')"'  >> $Output_File
done
rm -f $Temp_File 2> /dev/null
exit