: !/bin/sh

# create t21 acccode unload file
if [ "$1" = "" ]; then
	t21acccodefile="t21acccode.unl"
else
	t21acccodefile="$1"
fi
tmpt21acccodefile="/tmp/t21acccodetmp$$.unl"
rm -f "$t21acccodefile" "$tmpt21acccodefile"

runisql <<SQLCMD0
unload to "$tmpt21acccodefile" DELIMITER "|"
select acc_desc.siteid, acc_desc.account_code, acc_desc.account_desc, acc_grid.grid
from acc_desc, acc_grid
where acc_desc.siteid = acc_grid.siteid
  and acc_desc.account_code = acc_grid.account_code
order by 1,2,3,4
SQLCMD0

tr "," ";" <$tmpt21acccodefile | sort -u >$t21acccodefile

rm -f "$tmpt21acccodefile"

exit 0