Sybase Error – Cannot create join index with table(s) having column(s) of datatype %2. %1

In this blog post, you’ll learn more about the Sybase Error Cannot create join index with table(s) having column(s) of datatype %2. %1 and the reason for receiving this error

Sybase SQL Error Message

Cannot create join index with table(s) having column(s) of datatype %2. %1

Reason for this Error

The ‘join index’ functionality is supported on most datatypes. However, there are a few (e.g., long binary) for which this functionality is not supported.