我在会话级别出现错误。请帮我修复此问题 -
I am getting below error at session level. kindly help me to fix this -
READER_1_1_1> RR_4035 SQL错误[ [IBM] [CLI Driver] [ DB2 / AIX64] SQL0007NãÉååéãèmÉÄ@后面的字符无效。 SQLSTATE = 42601 sqlstate = 42601 数据库驱动程序错误...
READER_1_1_1> RR_4035 SQL Error [ [IBM][CLI Driver][DB2/AIX64] SQL0007N The character " " following "ÃãÉåÉãèmÉÄ@" is not valid. SQLSTATE=42601 sqlstate = 42601 Database driver error...
我在源限定符中写了一个SQL查询。查询是从三个表中提取数据,所以连接就在那里,条件是存在和子查询也是。虽然在源限定符中验证,它没有给出任何错误,甚至运行此查询在toad,它运行正常。
I have written a SQL query in source qualifier. Query is fetching data from three tables, so join is there,condition is there and sub-query is also. While validating in source qualifier, it not giving any error and even running this query in toad, it is running fine.
那么为什么我在会话级别收到此错误?是因为查询有子查询或与DB有一些连接问题?
So why I am getting this error at session level? Is it because query has sub-queries or some connection issues with DB?
我的数据库是DB2。
推荐答案我几乎确定你有一个编码问题。你的SQL可能被编码为UTF-8(只是通过检查错误消息中的垃圾),但驱动程序正在等待别的东西。
I'm almost certain you have an encoding issue. Your SQL is probably being encoded as UTF-8 (just by inspection of the junk in your error message), but the driver is expecting something else.
尝试指定编码您正在使用驱动程序,或使用驱动程序期望的编码
Try specifying the encoding you're using to the driver, or use the encoding that the driver expects
更多推荐
数据库驱动程序错误>>> “,遵循“Áãååéãè
发布评论