Shell Programming and Scripting

File1  -- 
Table11@column1@date@Table21@column1@varchar(10)@d;
Table11@column2@varchar@Table21@column2@date@d;
Table11@column3@varchar@Table21@column3@date@d;
............
Table11@column100@varchar@Table21@column100@date@d;
Table11@column101@varchar@Table21@column101@date@d;
............
Table11@column320@integer@Table21@column320@date@d;
............
Table19@column1@integer@Table29@column1@varchar@o;
Table19@column2@integer@Table29@column2@varchar@b;
Table19@column3@integer@Table29@column3@varchar@o;

awk -F "@" 'BEGIN { RS=";" ; OFS=","}
{
str="SUM(CASE WHEN T1." $2 "=T2." $5 " THEN 1 ELSE 0 END) " $2"_"$5
a[$1 OFS $4 OFS $7]=(a[$1 OFS $4 OFS $7] ? a[$1 OFS $4 OFS $7] ", \n" str : str
}
END {
for (i in a)
{
k=split(i,b,",")
print "SELECT " a[i] " FROM "b[1] " T1 \n INNER JOIN " b[2] " T2 \n ON T1.COLABC=T2.COLABC;" > "file_output.txt"
} }' File1.txt

SELECT SUM(CASE WHEN T1.column1=T2.column1 THEN 1 ELSE 0 END) column1_column1,
SUM(CASE WHEN T1.column2=T2.column2 THEN 1 ELSE 0 END) column2_column2,
......
SUM(CASE WHEN T1.column320=T2.column320 THEN 1 ELSE 0 END) column320_column320 FROM Table11 T1
INNER JOIN Table21 T2 
ON T1.COLABC=T2.COLABC;

SELECT SUM(CASE WHEN T1.column1=T2.column1 THEN 1 ELSE 0 END) column1_column1,
SUM(CASE WHEN T1.column2=T2.column2 THEN 1 ELSE 0 END) column2_column2,
......
SUM(CASE WHEN T1.column100=T2.column100 THEN 1 ELSE 0 END) column100_column100 FROM Table11 T1
INNER JOIN Table21 T2 
ON T1.COLABC=T2.COLABC;

SELECT SUM(CASE WHEN T1.column101=T2.column101 THEN 1 ELSE 0 END) column101_column101,
SUM(CASE WHEN T1.column102=T2.column102 THEN 1 ELSE 0 END) column102_column102,
......
SUM(CASE WHEN T1.column200=T2.column200 THEN 1 ELSE 0 END) column200_column200 FROM Table11 T1
INNER JOIN Table21 T2 
ON T1.COLABC=T2.COLABC;

.....

SELECT SUM(CASE WHEN T1.column301=T2.column301 THEN 1 ELSE 0 END) column301_column301,
SUM(CASE WHEN T1.column302=T2.column302 THEN 1 ELSE 0 END) column302_column302,
......
SUM(CASE WHEN T1.column320=T2.column320 THEN 1 ELSE 0 END) column320_column320 FROM Table11 T1
INNER JOIN Table21 T2 
ON T1.COLABC=T2.COLABC;

for (i in a) {
k=split(i,b,",")
for (z=1; z<=cnt[i]; (z+100))  {
y=get the z to z+99 SUM(CASE matching ones here
print "SELECT " y " FROM "b[1] " T1 \n INNER JOIN " b[2] " T2 \n ON T1.COLABC=T2.COLABC;" > "file_output.txt"
}
}

awk -F "@" '
BEGIN   {FMT1 = "%s%s\tSUM(CASE WHEN T1.%s=T2.%s THEN 1 ELSE 0 END) %s_%s"
         FMT2 = "\nFROM %s T1 INNER JOIN %s T2 ON T1.COLABC=T2.COLABC;\n\n"
        }
        {IX = $1 "," $4 "," $7
         ARR[IX "," ++CNT[IX]] = $2 "_" $5
        }
END     {for (c in CNT) {split  (c, TBL, ",")
                         printf "SELECT "
                         LC = 0
                         LF = DL = ""
                         for (i=1; i<=CNT[c]; i++)      {split (ARR[c "," i], COL, "_")
                                                         printf FMT1, DL, LF, COL[1], COL[2], COL[1], COL[2]
                                                         DL = ","
                                                         LF = "\n"
                                                         if (!(++LC%LNMX) &&
                                                                i<CNT[c])       {printf FMT2, TBL[1], TBL[2] 
                                                                                 printf "SELECT "
                                                                                 DL = LF = ""
                                                                        }
                                                        }
                         printf FMT2, TBL[1], TBL[2] 
                        }
        }
' LNMX=3 file
SELECT 	SUM(CASE WHEN T1.column1=T2.column1 THEN 1 ELSE 0 END) column1_column1,
	SUM(CASE WHEN T1.column3=T2.column3 THEN 1 ELSE 0 END) column3_column3
FROM Table19 T1 INNER JOIN Table29 T2 ON T1.COLABC=T2.COLABC;

SELECT 	SUM(CASE WHEN T1.column2=T2.column2 THEN 1 ELSE 0 END) column2_column2
FROM Table19 T1 INNER JOIN Table29 T2 ON T1.COLABC=T2.COLABC;

SELECT 	SUM(CASE WHEN T1.column1=T2.column1 THEN 1 ELSE 0 END) column1_column1,
	SUM(CASE WHEN T1.column2=T2.column2 THEN 1 ELSE 0 END) column2_column2,
	SUM(CASE WHEN T1.column3=T2.column3 THEN 1 ELSE 0 END) column3_column3
FROM Table11 T1 INNER JOIN Table21 T2 ON T1.COLABC=T2.COLABC;

SELECT 	SUM(CASE WHEN T1.column100=T2.column100 THEN 1 ELSE 0 END) column100_column100,
	SUM(CASE WHEN T1.column101=T2.column101 THEN 1 ELSE 0 END) column101_column101,
	SUM(CASE WHEN T1.column320=T2.column320 THEN 1 ELSE 0 END) column320_column320
FROM Table11 T1 INNER JOIN Table21 T2 ON T1.COLABC=T2.COLABC;