Unrecognized and unsupported SQLTYPES
The values that appear in the SQLTYPE field of the SQLDA are dependent on the level of data type support available at the sender as well as at the receiver of the data. This support is particularly important as new data types are added to the product.
New data types might not be supported by the sender or receiver of the data and might not be recognized by the sender or receiver of the data. Depending on the situation, the new data type might be returned, a compatible data type that is agreed to by both the sender and the receiver of the data might be returned, or an error might occur.
When the sender and receiver agree to use a compatible
data type, the following table indicates the mapping that takes place.
This mapping takes place when at least one of the sender or receiver
does not support the data type provided. The unsupported data type
can be provided by either the application or the database manager.
| Data type | Compatible data type |
|---|---|
| ROWID | VARCHAR(40) FOR BIT DATA |
No indication is given in the SQLDA that the data type is substituted.