Shell Programming and Scripting

[akshay@nio tmp]$ cat infile
CREATE TABLE TAB1
(
COL1,
COL2
);

CREATE UNIQUE INDEX XPKTAB1
(
COL1
)TAB1;

CREATE TABLE TAB2
(
COL1,
COL2
);

CREATE UNIQUE INDEX XPKTAB2
(
COL2
)TAB2;

[akshay@nio tmp]$ cat run.awk
function dothis(){ 
	if(s==2)
	{
		split(p,S,/;/); split(S[2],E,/[()]/) 
		gsub(/[()]/,"\n&",S[1]); gsub(/[(,]/,"&\n",S[1])
		printf("%sINDEX %s(%s);\n\nCOMMENT ON %s \042PK=,%s\042;\n\n", S[1],E[3],E[2],E[3],E[2]) 
		p = s = ""
	}
}
{
	dothis()
	s += /).*;/
	p  = p $0
} 
END{
	dothis()
}

[akshay@nio tmp]$ awk -f run.awk infile

CREATE TABLE TAB1
(
COL1,
COL2
)INDEX TAB1(COL1);

COMMENT ON TAB1 "PK=,COL1";

CREATE TABLE TAB2
(
COL1,
COL2
)INDEX TAB2(COL2);

COMMENT ON TAB2 "PK=,COL2";