Shell Programming and Scripting

create table salary
( occupation_code char(40),
  earnings decimal(10,2),
  occ_yearend integer
);

salary:create table salary
salary:( occupation_code char(40),
salary:  earnings decimal(10,2),
salary:  occ_yearend integer
salary:);

awk 'NR==1{x=$3}{$0=x":"$0}1' file

create table contract_occ
( occupation_code char(40),
  con_ref int,
  cntrctid_number char(20));
create table salary
( occupation_code char(40),
  earnings decimal(10,2),
  occ_yearend integer);
...

contract_occ:create table contract_occ
contract_occ:( occupation_code char(40),
contract_occ:  con_ref int,
contract_occ:  cntrctid_number char(20));
salary:create table salary
salary:( occupation_code char(40),
salary:  earnings decimal(10,2),
salary:  occ_yearend integer);
...

awk '/create table/{x=$3}{$0=x":"$0}1' file

while read line
do
    if [ `echo $line | grep "create table " | wc -l` -gt 0 ]
    then
        tablename=`echo $line | awk '{print $3}'`
    fi
        echo "$tablename:" $line >> outfile
done < infile