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