This article explains that a No records displayed message using SQLWizard is due to hex values in the data.
Problem:
First I clicked SQL for DB2 on the Tools menu, and then on SQL Wizard. In the browser window, I highlighted and selected the table to edit. Then I chose Select Allow Editing. I then edited a column value in a row and clicked the X to close the table. A message pops up asking if you want to save the changes and I clicked yes. Then a message box was displayed describing the error:
No records displayed
Is there possibly non-displayable data in the character field? The columns which may contain non-displayable characters are listed.
Resolution:
There is hex data in the table. SQLWizard is attempting to put together an UPDATE that will modify the data. It will use the existing values to find the rows to be updated. The original data with the binary information will still be in the table and the UPDATE won't find the row.
To get this to work, use Hex Display for the columns that the error message says contain binary data. Right click in the result set on the columns and select Hex Display for each of the three columns. Then modify the data and now SQLWizard will build an UPDATE statement containing hex strings instead of the actual data and the update should work.
Incident Number: 2356472
#MFDS
#EnterpriseDeveloper
