: !/bin/sh

# create t21 extranges unload file
if [ "$1" = "" ]; then
	t21extrangesfile="t21extranges.unl"
else
	t21extrangesfile="$1"
fi
tmpt21extrangesfile="/tmp/t21extrangestmp$$.unl"
rm -f "$t21extrangesfile" "$tmpt21extrangesfile"

runisql <<SQLCMD0
unload to "$tmpt21extrangesfile" DELIMITER "|"
select * from extranges
order by siteid,lorange
SQLCMD0

tr "," ";" <$tmpt21extrangesfile | sort -u >$t21extrangesfile

rm -f "$tmpt21extrangesfile"

exit 0