: !/bin/sh

#txsql -s -h -d catcom -F "|" <<SQLCMD1
#txsql -d catcom -F "|" 2>/dev/null <<SQLCMD1
txsql -d catcom -F "|" <<SQLCMD1
drop table tHier;
create table tHier 
(
	parentgrid char(20),
	grid char(20),
	grtype char(1),
	grlevel char(1),
	grname1 char(25),
	grname2 char(25),
	grname3 char(40)
);
create index i_tHier1 on tHier (grid);
SQLCMD1

exit 0