##Get database user and pass logon_file=logon.env pass_ret=`echo "select '\$TD_USER' as MYUSER, '\$TD_PASS' as MYPASS;"|dsql -c ${logon_file}` td_user=`echo "$pass_ret"|grep "MYUSER"|grep "="|awk -F "=" '{print $2}'` td_pass=`echo "$pass_ret"|grep "MYPASS"|grep "="|awk -F "=" '{print $2}'`