DB2 执行SQL脚本
今天有网友问到这个问题，平时也没怎么留意。刚刚做了测试在db2的SQL脚本中，直接写命令就好了。例如：
$ cat test.ddl
--------------------------------------
insert into t3 values (123,'SQL');
select * from t3;
--------------------------------------
如果写成：
----------------------------------------------
db2 "insert into t3 values (123,'SQL')";
db2 "select * from t3";
----------------------------------------------
$ db2 -tvf test.ddl
db2 "insert into t3 values (1123,'SQL')"
SQL0104NAn unexpected token "db2" was found following "BEGIN-OF-STATEMENT".
Expected tokens may include:"SELECT".SQLSTATE=42601
db2 "select * from t3"
SQL0104NAn unexpected token "db2" was found following "BEGIN-OF-STATEMENT".
Expected tokens may include:"SELECT".SQLSTATE=42601
语句后面要写分号，其他符号也可以，需要指定。
上面指出了，脚本中每行命令首不要带db2
再看一看删除table的脚本：
$ cat dropexplain.ddl
connect to mydb1
drop table EXPLAIN_ACTUALS
drop table EXPLAIN_ARGUMENT
connect reset
执行：
$ db2 -tvf dropexplain.ddl
DB21007EEnd of file reached while reading the command.
可是还是执行不成功，注意：脚本的结尾一定要有分隔符。修改成下面这样就好了。
$ cat dropexplain.ddl
connect to mydb1;
drop table EXPLAIN_ACTUALS ;
drop table EXPLAIN_ARGUMENT ;
connect reset;
执行：
$ 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
DB20000IThe SQL command completed successfully.
drop table EXPLAIN_ARGUMENT
DB20000IThe SQL command completed successfully.
connect reset
DB20000IThe SQL command completed successfully.
页:
[1]