DB2 执行SQL脚本

今天有网友问到这个问题，平时也没怎么留意。刚刚做了测试在db2的SQL脚本中，直接写命令就好了。

例如：

[db2inst1@win backups]$ cat test.ddl 
--------------------------------------
insert into t3 values (123,'SQL');
select * from t3;
--------------------------------------

如果写成：

----------------------------------------------
db2 "insert into t3 values (123,'SQL')";
db2 "select * from t3";
----------------------------------------------

[db2inst1@win backups]$ db2 -tvf test.ddl
db2 "insert into t3 values (1123,'SQL')"
SQL0104N An unexpected token "db2" was found following "BEGIN-OF-STATEMENT".
Expected tokens may include: "SELECT". SQLSTATE=42601

db2 "select * from t3"
SQL0104N An unexpected token "db2" was found following "BEGIN-OF-STATEMENT".
Expected tokens may include: "SELECT". SQLSTATE=42601

语句后面要写分号，其他符号也可以，需要指定。

上面指出了，脚本中每行命令首不要带db2

再看一看删除table的脚本：

[db2inst1@win ~]$ cat dropexplain.ddl 

connect to mydb1
drop table EXPLAIN_ACTUALS                                                                                                                 
drop table EXPLAIN_ARGUMENT  
connect reset

执行：

[db2inst1@win ~]$ db2 -tvf dropexplain.ddl 

DB21007E  End of file reached while reading the command.

可是还是执行不成功，注意：脚本的结尾一定要有分隔符。修改成下面这样就好了。

[db2inst1@win ~]$ cat dropexplain.ddl 
connect to mydb1;    
drop table EXPLAIN_ACTUALS ;                                                                                                                
drop table EXPLAIN_ARGUMENT ;                                                                                                               
connect reset;

执行：

[db2inst1@win ~]$ db2 -tvf dropexplain.ddl 
connect to mydb1

   Database Connection Information

 Database server        = DB2/LINUXX8664 10.1.0
 SQL authorization ID   = DB2INST1
 Local database alias   = MYDB1


drop table EXPLAIN_ACTUALS 
DB20000I  The SQL command completed successfully.

drop table EXPLAIN_ARGUMENT 
DB20000I  The SQL command completed successfully.

connect reset
DB20000I  The SQL command completed successfully.