: !/bin/sh

# create t21wbdexclude unload file
if [ "$1" = "" ]; then
	t21wbdexcludefile="t21wbdexclude.unl"
else
	t21wbdexcludefile="$1"
fi
tmp1file="/tmp/t21wbdexcludetmp1$$.unl"
rm -f "$t21wbdexcludefile"
rm -f "$tmp1file"

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

gett21wbdexclude()
{
	rm -f "$tmp1file"
	runisql <<SQLCMD0
	unload to "$tmp1file" DELIMITER "|"
	select * from wbdexclude
	order by 1,2,3
SQLCMD0
}

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

(
gett21wbdexclude ""
tr "," ";" <$tmp1file | sort -u >$t21wbdexcludefile
) 2>&1 | tee $0.log

rm -f "$tmp1file"

exit 0