"Cannot create the join index because the datatype of the underlying join virtual table column is not equal to the datatype of the corresponding base table column '%1'."
| Item | Description |
|---|---|
|
SQLCode |
-1008011L |
|
Constant |
EMSG_IQ_BASEANDJVT_COL |
|
SQLState |
QNA11 |
|
ODBC 2 State |
ERROR |
|
ODBC 3 State |
ERROR |
|
Sybase Error Code |
20685 |
|
Severity Code |
|
|
Parameter 1 |
column name |
The underlying jvt column and the corresponding base table column must be of the same datatype in order to create a join index. One way to get this error is to create a join index on tables containing FLOAT columns with a client application that uses an open client (isql) or JDBC (Sybase Central) connection. For such connections, the database option FLOAT_AS_DOUBLE defaults to ON thereby creating jvt columns as type DOUBLE for the FLOAT columns in the base tables. To create the join using one of these tools, the user must first set FLOAT_TO_DOUBLE to OFF. See the 'Database Options' chapter in the ASIQ Reference Manual for details on Database Options.