linux 命令行连接gbase8s
#!/bin/sh
function select_meth() {
user=$1
passwd=$2
tbname=$3
dbname=$4
echo """
connect to '${dbname}@gbase202' user $user using $passwd;
select * from trade limit 10;""" >tmp.sql
if [[ -f tmp.sql ]];then
dbaccess - tmp.sql
fi
}
dbname='dbt5'
export DBACCESS_SHOW_TIME=1
select_meth "gbasedbt" "111111" "trade" $dbname