: !/bin/sh

. tbsserver_vars

tablename="$1"

if [ -n "$2" ]; then
	outfile="$2"
else
	outfile="${tablename}.unl"
fi

if [ "$outfile" = "-" ]; then
	outfile=""
fi

(
sqsh -S $server -D $dbname -U $username -P $password <<SQLCMD0
select * from ${tablename}
\go -m bcp
SQLCMD0
) | tr "," ";" >$outfile

#cat $outfile