In this blog post, you’ll learn more about the Sybase Error CMP index can only be created on two distinct columns having identical datatypes. %1 and the reason for receiving this error
Sybase SQL Error Message
CMP index can only be created on two distinct columns having identical datatypes. %1
Reason for this Error
A CMP index is an index that can be only created on two columns. You cannot create a single column CMP index; nor can you create a CMP index on three or more columns. Furthermore, when specifying two columns, the two columns must have identical datatypes.