SQL0010N does not have an ending string delimiter
来源:互联网 发布:打开钱箱的软件 编辑:程序博客网 时间:2024/04/30 12:10
在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就好了
0 0
- SQL0010N does not have an ending string delimiter
- Animator does not have an AnimatorController
- sqldeveloper 调试时出现“ocal host machine does not have an IP address ”错误
- C# Issues and Solutions -- Method get_XXX from assembly YYYY does not have an implementation
- L6305W: Image does not have an entry point. (Not specified or not set due to multiple choices.)
- Warning: L6305W: Image does not have an entry point. (Not specified or not set due to multi
- javax.el.PropertyNotFoundException: The class 'java.lang.String' does not have the property 'XXX'
- Scene is unreachable due to lack of entry points and does not have an identifier for runtime access
- Scene is unreachable due to lack of entry points and does not have an identifier for runtime access
- 警告: Scene is unreachable due to lack of entry points and does not have an identifier for runtime acc
- Scene is unreachable due to lack of entry points and does not have an identifier for runtime access
- java 正则表达式报错:Look-behind group does not have an obvious maximum length near index
- Swift: 消除警告-Scene is unreachable due to lack of entry points and does not have an identifier for
- DataDindow does not have UPDATE capability
- Your host does not have synchronized TSCs
- xcode 5 does not have gcc
- application does not have sufficient geolocation permissions
- ftok() ENOENT: A component of path does not exist, or path is an empty string.
- Linus:利用二级指针删除单向链表
- 参考Dedecms整合Discuz完全攻略实现最新的结合
- 16个使用精美字体的欧美网页设计欣赏
- ARC在IBOutlet属性中的使用
- iOS-Core-Animation之十五----图层性能
- SQL0010N does not have an ending string delimiter
- codeforces--55D--Beautiful numbers(数位dp,dfs+记忆化)
- 树莓派Rpi编译更换 内核
- (转载)linux命令之三十五wc命令
- SNMPv1原理
- 我的blog
- [学习笔记]学习主题模型(Topic Model)和PLSA( probabilistic latent semantic analysis)
- Linux串口(serial、uart)驱动程序设计
- MySQL事务隔离级别详解