: !/bin/sh

# create t21groups3 unload file
if [ "$1" = "" ]; then
	t21groups3file="t21groups3.unl"
else
	t21groups3file="$1"
fi
tmpt21groups3file="/tmp/t21groups3tmp$$.unl"
tmp1t21groups3file="/tmp/t21groups3tmp1$$.unl"
rm -f "$t21groups3file" "$tmpt21groups3file" "$tmp1t21groups3file"

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

getallt21groups()
{
	rm -f "$tmp1t21groups3file"
	runisql <<SQLCMD0
	unload to "$tmp1t21groups3file" DELIMITER "|"
	select parentgroupid, groupname.grid, grtype, grname1, grname2, grname3
	from groupname, gnextra, outer gengroup
	where groupname.grid = gengroup.childgroupid
	  and groupname.grid = gnextra.grid
	order by parentgroupid, groupname.grid
SQLCMD0
	cat "$tmp1t21groups3file" >> "$tmpt21groups3file"
	rm -f "$tmp1t21groups3file"
}

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

(
getallt21groups
tr "," ";" <$tmpt21groups3file | sort -u >$t21groups3file
) 2>&1 | tee $0.log

rm -f "$tmpt21groups3file" "$tmp1t21groups3file"

exit 0