echo "dbaccess dbname<<!">dbbak.sh
dbschema -d dbname -t all|grep TABLE|awk -F. '{print $2}'|awk '{print "unload to "$1".txt select * from "$1";"}'>>dbbak.sh
echo "!">>dbbak.sh
chmod +x dbbak.sh
运行dbbak.sh就能自动将dbname数据库中的所有表导成文本了。
echo "dbaccess dbname<<!">dbbak.sh
dbschema -d dbname -t all|grep TABLE|awk -F. '{print $2}'|awk '{print "unload to "$1".txt select * from "$1";"}'>>dbbak.sh
echo "!">>dbbak.sh
chmod +x dbbak.sh
运行dbbak.sh就能自动将dbname数据库中的所有表导成文本了。