Question & Answer
Question
When updating a row or table, SQLCODE100 occurs when unintended characters are in the DB2 column.
Answer
For DB2 Table Editor, the following error can occur while running the SQL statement to update a row or table:
"No row was found for fetch, update or delete; or the result of the query is an empty table" SQLCode= +100, sqlstate 02000".
To resolve this SQLCODE100 issue, ensure that unintended characters are not in the DB2 column being used in the SQL predicate (the 'WHERE' clause in the SQL).
Unintended characters can be caused if you populate the DB2 table with data from an Excel database by cutting and pasting from Excel to the DB2 table. When a cut and paste is performed, control characters can be picked up and transferred to the DB2 table, resulting in unintended characters; for example, a hollow square.
After you delete the unwanted characters, the SQL statement to update a row or table can be performed.
[{"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"DB2 Table Editor","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"4.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
11 February 2021
UID
swg21144332