使用shell从DB2数据库导出数据

-p "please input your DBNAME: " DBNAME read -p "please input your username: " username read -p "please input your password: " password db2 connect to $DBNAME user $username using $password db2 "EXPORT to /home/Practice/data/a.del of del select * from A"

（2）连接Linux，使用下面命令执行

su - db2inst1 -c "/home/Practice/a.sh"

上面这条代码是关键，其中a.sh文件存储在/home/Practice路径下

[root@localhost Practice]# chmod +x a.sh
[root@localhost data]# su - db2inst1 -c "/home/Practice/a.sh"
please input your DBNAME: oliverdb
please input your username: db2inst1
please input your password: db2inst1

   Database Connection Information

 Database server        = DB2/LINUXX8664 10.5.5
 SQL authorization ID   = DB2INST1
 Local database alias   = OLIVERDB

SQL3104N  The Export utility is beginning to export data to file 
"/home/Practice/data/a.del".

SQL3105N  The Export utility has finished exporting "2" rows.


Number of rows exported: 2

到此处为止，数据已经从数据库oiliverDB导出到了目录/home/Practice/data下。

 

使用shell从DB2数据库导出数据

标签：

本文系统来源：http://www.cnblogs.com/OliverQin/p/5889244.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！