DB2 Error Code 306 – The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

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.