#! /bin/sh

. qsmserver_vars

tablename="$1"

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

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

echo "using: sqsh -S $server -D $dbname -U $username -P $password"
(
sqsh -S $server -D $dbname -U $username -P $password <<SQLCMD0
select * from ${tablename}
\go -m bcp
SQLCMD0
) | tr "," ";" | \
(
	if [ -z "$outfile" ]; then
		cat
	else
		cat >"$outfile"
	fi
)

#cat $outfile