在linux下执行db2 -tvf xx.sql时,如果sql中包含中文字母,就有可能出现下面错误情况
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command.
During SQL processing it returned: SQL0010N The string constant beginning with "'管理员')" does not have an ending
string delimiter. SQLSTATE=42603

因为DB2字符集没有设置正确,sql文件中的编码为UTF-8.而DB2读取sql语句采用的是GBK,因此需要设置字符集
查看原来的字符集
[$] db2set -all
[i] DB2CODEPAGE=1386
设置为1208
[$] db2set db2codepage=1208
执行一遍db2 -tvf xx.sql就好了