: !/bin/sh

# get dbaname to use
. tbsserver_vars

# note: /u/catcom/sqsh_vars is used to get sqlserver info

txsql.sqsh -d "$dbname" -h -s -q "select * from tPerson order by 2" >tbs1.out