Shell Programming and Scripting

CREATE MULTISET TABLE TEST
(
COLUMN1 CHAR(30) NULL,
COLUMN2 DECIMAL(8,2) NOT NULL,
COLUMN3 INTEGER
)

CREATE MULTISET TABLE TEST1
(
COLUMN4 VARCHAR(30) NULL,
COLUMN5 DECIMAL(8,2) NOT NULL,
COLUMN6 INTEGER
)

CREATE MULTISET TABLE TEST1
  (
     COLUMN5 DECIMAL(8,2) NOT NULL,
COLUMN4 VARCHAR(30) NULL,
COLUMN6 INTEGER
  )
 
CREATE MULTISET TABLE TEST
(
COLUMN1 CHAR(30) NULL,
COLUMN3 INTEGER
COLUMN2 DECIMAL(8,2)  NULL,
)

sed 's/^ *//;s/ *$//;s/ +/ /' file1 > newfile1
sed 's/^ *//;s/ *$//;s/ +/ /' file2 > newfile2

awk '/^CREATE/{key=$NF} {print > key "." FILENAME}' new*

for file in *.newfile1
do
  Key=`echo ${file%.*}`
  echo "********  compare the key $Key **********"
  diff $file $Key.newfile2
done


********  compare the key TEST **********
4d3
< COLUMN2 DECIMAL(8,2) NOT NULL,
5a5
> COLUMN2 DECIMAL(8,2)  NULL,
7d6
<
********  compare the key TEST1 **********
3d2
< COLUMN4 VARCHAR(30) NULL,
4a4
> COLUMN4 VARCHAR(30) NULL,
6a7
>