: !/bin/sh

# create chargecat unload file
if [ "$1" = "" ]; then
	chargecatfile="chargecat.unl"
else
	chargecatfile="$1"
fi
tmpchargecatfile="/tmp/chargecattmp$$.unl"
rm -f "$chargecatfile" "$tmpchargecatfile"

runisql <<SQLCMD0
unload to "$tmpchargecatfile" DELIMITER "|"
select * from chargecat
order by importdatatypeid, carriercode, rectype, chargecat, chargeclasstype;
SQLCMD0

tr "," ";" <$tmpchargecatfile >$chargecatfile

rm -f "$tmpchargecatfile"

exit 0