Limitations
- Last Updated: January 21, 2019
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
- The Sybase server ensures the accuracy of Real data type values only up to 6 digits.
- For the Money data type, if an application submits a value with a scale larger than 4, the driver changes the scale to 4 by truncating the value. Ideally, it should set the scale to 4 and round off the value. For example, if the value is 100.141592, the driver truncates it to 100.1415. Instead, it should round it off to 100.1416.
- The driver does not support inserting data containing LOB columns. In such cases, the driver throws a warning and falls back to the native protocol to continue executing the inserts.
- When executing an insert statement, the operation will fail with an error message if non-identity columns are omitted from a statement.