: !/bin/sh

# create t21g3e unload file
if [ "$1" = "" ]; then
	t21g3efile="t21g3e.csv"
else
	t21g3efile="$1"
fi
tmpt21g3efile="/tmp/t21g3etmp$$.unl"
tmp1t21g3efile="/tmp/t21g3etmp1$$.unl"
rm -f "$t21g3efile" "$tmpt21g3efile" "$tmp1t21g3efile"

###############################

gett21g3e()
{
	grid=$1
	rm -f "$tmp1t21g3efile"
	runisql <<SQLCMD0
	unload to "$tmp1t21g3efile" delimiter "|"
	select unique  grname3, grname2, extension
	from groupname, gengroup, gnextra, directtemplate
	where groupname.grid = gengroup.childgroupid
	  and groupname.grid = gnextra.grid
	  and groupname.grid = directtemplate.extgroupunique
	order by 1, 2, 3
SQLCMD0
	cat "$tmp1t21g3efile" >> "$tmpt21g3efile"
	cat "$tmp1t21g3efile"
	rm -f "$tmp1t21g3efile"
}

##############################

(
gett21g3e "" >> $tmpt21g3efile
tr "," ";" <$tmpt21g3efile | tr "|" "," | sed -e 's/,$//' | sort -u >"$t21g3efile"
) 2>&1 | tee $0.log

rm -f "$tmpt21g3efile" "$tmp1t21g3efile"

emailaddr="bilmax21"
ematt "$t21g3efile" "CC Extns CSV" "$emailaddr"

exit 0