- 论坛徽章:
- 0
|
用db2实例用户登陆后
db2inst1@linux:~> db2 connect to sample
Database Connection Information
Database server = DB2/LINUXX8664 9.1.5
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
db2inst1@linux:~> db2 select * from org
SQL0104N An unexpected token "Documents" was found following "select bin
db2inst1". Expected tokens may include: ",". SQLSTATE=42601
但是把语句放在文件里
db2inst1@linux:/hechao> cat sql.txt
connect to sample
select * from org
connect reset
db2 => db2inst1@linux:/hechao> db2 < sql.txt 确实成功的.. |
|