Encounter 206 this mistake, but my SQL statement did not write wrong ah!
Baidu said that my SQL statement is not the field wrong, but checked several times but there is no problem, my SQL statement is:
update ZZC_ANTI_REPORT_HIT_RULES_LIST set APP_NO="33" where org="000000000005"is really best not sister;
The final solution is that the scripting environment of dbVisualiazer cannot use double quotes, it must be single quotes; Oh, really.
update ZZC_ANTI_REPORT_HIT_RULES_LIST set APP_NO='33' where org='000000000005'
Read More:
- Solve a bug harvest of DB2 (sqlcode = – 805, sqlstate = 51002, error message = DB2 SQL error: sqlcode = – 805, sqlstate = 5100
- DB2 SQL error: SQLCODE: -433, SQLSTATE: 22001, SQLERRMC
- DB2 SQL ERROR: SQLCODE=-803, SQLSTATE=23505, SQL
- DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;,?,?,?,?,?,?,?,?);END-OF-STATEMENT
- DB2 SQL error: sqlcode = – 433, sqlstate = 22001 solved
- DB2 SQL error: sqlcode = – 803, sqlstate = 23505, sqlerrmc = 2 [solution]
- Error when connecting to database: DB2 SQL error: sqlcode = – 204, sqlstate = 42704, sqlerrmc= YXUAT.CUST_ BLK_ REL, DRIVER=4.25.13
- DB2, create stored procedure error, sqlcode = – 104, sqlstate = 42601, PSM_ semicolon
- SQLCODE=-551, SQLSTATE=42501 error resolution
- DB2 encountered the problem of sqlcode = 911 lock table when updating record update
- SQL error: 17006, sqlstate: 99999 invalid column name
- SQL Error: 17059, SQLState: 99999
- SQL Error: 1452, SQLState: 23000
- SQL Error: 904, SQLState: 42000
- SQL Error: 0, SQLState: 08S01 & Communications link failure
- DB2 sql5005c system exception
- DB2 create table error – 104 42601 illegal symbol encountered in SQL statement
- SQL error: 156, sqlstate: S1000 error encountered in Hibernate
- How to Fix SQL Error: 1054, SQLState: 42S22 Unknown column ‘markcardex0_.art_service_time’ in ‘field list’
- A case diagnosis and solution of DB2 error code 1639 and SQL state 08001 is described in detail