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.