In this post, you’ll learn about the DB2 error 306-The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. and the reason why you are receiving the error message and how to fix it
How does this Error Message Looks like
306 – The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
Reason for the Error & Solution
A query ordering was attempted on a field that is mapped to a CLOB or BLOB, which is disallowed by SQLServer.