Shell Programming and Scripting

tab1=$1
 
if [ ! -f $tab1 ] ; then
echo "file1 not exist:$tab1"
fi
col1=`awk -F" " '/SET TABLE/{print substr($4,(index($4,".")+1))}1'  $tab1 |egrep -iv 'create|journal|default|index'| sed -e 's/(//g' -e 's/)//g'|awk -F " " '{print $1 }'|awk NF`
 
len1=`awk -F" " '/SET TABLE/{print $4}1'  $tab1 |egrep -iv 'create|journal|default|index'|awk -F " " '{print $2 }'`
echo "$col1 $len1\n"
 

a.sql

CREATE SET TABLE HIST ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
Id INTEGER NOT NULL,
Cd CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
Category_Cd VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
Start_Dt DATE FORMAT 'YYYY-MM-DD' NOT NULL,
Ind CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
End_Dt DATE FORMAT 'YYYY-MM-DD'
)PRIMARY INDEX ( Party_Id );

#gelcol.sh a.sql

HIST
Id
Cd
Category_Cd
Start_Dt
Ind
End_Dt 
 
INTEGER
CHAR(10)
VARCHAR(5)
DATE
CHAR(1)
DATE

O/p should be 

Id                INTEGER
Cd                CHAR(10)
Category_Cd       VARCHAR(5)
Start_Dt          DATE
Ind               CHAR(1) 
End_Dt            DATE