Error 1000198

Message text

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

Item

Value

SQLCode

-1000198L

Constant

EMSG_CANNOT_CREATE_JOIN_INDEX

SQLState

QDB98

ODBC State

ERROR

Parameter 1

location of the exception

Parameter 2

data type of column

Probable cause

This error is reported when you attempt to create a join index on a table that has one or more LONG VARCHAR or LONG BINARY data type columns. The JOIN INDEX functionality is supported for most data types. There are a few data types, however, for which this functionality is not supported (for example, LONG BINARY and LONG VARCHAR).