Error 1000114

"CMP index can only be created on two distinct columns having identical datatypes. %1"

Item	Description
SQLCode	-1000114L
Constant	EMSG_CMP_NOT_ON_TWOCOLUMNS
SQLState	QDB14
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Sybase Error Code	20774
Severity Code	14
Parameter 1	location of the exception

Probable cause

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.