linux 命令行连接gbase8s

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