【Teradata DSQL】获取env中的用户和口令到变量中(无需落地到文件中)

##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}'`
posted @ 2019-05-22 17:33  李子恒  阅读(260)  评论(0编辑  收藏  举报