Limitations
- Last Updated: December 20, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- Documentation
- The SAP ASE 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.