Symptom
When connecting via a TDS connection type (jdbc, open client) there are different options set than when connecting via ODBC or using DBISQL.
- If you are working with structured datatypes like:
- DATE
- DATETIME
- TIME
- etc
- Default setting can result in conversation errors similar to:
[Sybase][JDBC Driver][Sybase IQ]Cannot convert 12-31-2017 to a datetime(23) (column c1) - Or when exporting the data, the results may not be in the desired format (see KBA 3101035)
Read more...
Environment
- SAP IQ 16.0
- SAP IQ 15.4
- SAP Sybase IQ 15.2
Product
SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4
Keywords
KBA , BC-SYB-IQ , Sybase IQ , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.