Shell Programming and Scripting

!/bin/sh
#read.sh
sed -n '/ALTER/,/;/p' new.txt > data.txt
sed '/;/ a\
        ' data.txt > data.ex
/usr/xpg4/bin/awk '
NR==FNR {
tbl[$1]++;
next;
}
/ALTER TABLE/ {
tbl_name = $3;
if (tbl_name in tbl)
        getcols = 1
   else getcols = 0;
   next;
}
 
getcols != 1 {
 printf "%-12s\t %-12s\n" , tbl_name , "NOT FOUND";
next ;
}
/^ADD/,/;[[:space:]]*$/ {
f = ($1 ~ /^ADD/ ? 3 : 1);
sub(/).*/, ")", $(f+1));
printf "%-12s\t %-12s\t %s\t %s\n" , tbl_name, $f, $(f+1) , "NOT NULL";
 
}
 
' table data.ex > result
echo "
1i
"`grep "DDCF No." new.txt`"\n
.
wq
" | ex -s result
cut -d"|" -f3 result | sort -u | tee result1