/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
- Selecting a remote column with a LIKE clause may receive wrong result if the remote server's collation is different from that of the local server.
- CIS (Component Integration Service) is used.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- DirectConnect for DB2 (ODBC 15.0/15.7)
- DirectConnect for DB2 15.0.1
- DB2 (any supported version, 8, 9, 10)
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Sybase Mainframe Connect 15.0 ; Sybase Enterprise Connect Data Access all versions ; Sybase EnterpriseConnect Data Access 15.7 ; Sybase MainframeConnect 15.0
Keywords
predicate pushdown error, string comparison semantics, prefix match failure, pattern matching discrepancy, search condition transformation issue, lexicographical range mismatch, nonmatching range bounds, federation behavior, heterogeneous access, optimizer bug, SQL predicate decomposition, data federation, locale mismatch, sort order mismatch, string range evaluation, Component Integration Service, Direct Connect, CR750720, CR#750720, 750720 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-SDK , SDK , BC-SYB-MFC , Mainframe Connect (MFC) , BC-SYB-ECD , Enterprise Connect (ECDA) , Problem
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.
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)