Error 1000198

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

Item	Description
SQLCode	-1000198L
Constant	EMSG_CANNOT_CREATE_JOIN_INDEX
SQLState	QDB98
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Sybase Error Code	20858
Severity Code	14
Parameter 1	location of the exception
Parameter 2	datatype of column

Probable cause

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.