Problem:

When showing BLOB or CLOB data stored in a table, the column(s) is highlighted and a "Blob not found" error might be displayed. 


Solution:

Set the driver property JDBCTEMP = <absolute-folder-path> for the database connection. More info:

https://www.ibm.com/support/pages/error-79701-blob-not-found-while-retrieving-blobs-problem-creating-temporary-files


To do so, open your Informix connection in DbVisualizer, switch to the Properties tab and select the Driver Properties category. Insert a new row and set Parameter to JDBCTEMP and Value to an absolute path. Connect and give it a test.