: !/bin/sh

# create dataplan unload file
if [ "$1" = "" ]; then
	dataplanfile="dataplan.unl"
else
	dataplanfile="$1"
fi
tmpdataplanfile="/tmp/dataplantmp$$.unl"
rm -f "$dataplanfile" "$tmpdataplanfile"

runisql <<SQLCMD0
unload to "$tmpdataplanfile" DELIMITER "|"
select * from dataplan
order by dataplan, chargecat
SQLCMD0

tr "," ";" <$tmpdataplanfile >$dataplanfile

rm -f "$tmpdataplanfile"

exit 0