: !/bin/sh

# create t21rt unload file
if [ "$1" = "" ]; then
	t21rtfile="t21rt.unl"
else
	t21rtfile="$1"
fi
tmp1t21rtfile="/tmp/t21rttmp1$$.unl"
rm -f "$t21rtfile"

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

(
rm -f "$tmp1t21rtfile"
runisql <<SQLCMD0
unload to "$tmp1t21rtfile" DELIMITER "|"
select rt.*, rte.* , rti.*, site.sitenm1
from routetrunk rt, rtextra rte, outer rtipaddr rti, outer site
where rt.siteid = rte.siteid
  and rt.routeid = rte.routeid
  and rt.trunklocalid = rte.trunklocalid
  and rt.siteid = rti.siteid
  and rt.routeid = rti.routeid
  and rt.trunklocalid = rti.trunklocalid
  and rt.siteid = site.siteid
order by rt.siteid, rt.routeid, rt.trunklocalid
SQLCMD0
tr "," ";" <$tmp1t21rtfile | sort -u >$t21rtfile
) 2>&1 | tee $0.log

rm -f "$tmp1t21rtfile"

exit 0