今天有网友问到这个问题，平时也没怎么留意。刚刚做了测试在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.