SAP Knowledge Base Article - Preview

2834738 - Collate function in optimized SQL - SAP Data Services 14.2.x

Symptom

SAP Data Services optimized SQL contains the following SQL for an ORDERBY:

ORDER BY "TCRdr_8"."Col2" COLLATE Latin1_General_BIN2 ASC

Even though the source, target and repository database are using the collation Latin1_General_CS_AS and the SAP Data Services AL_Engine is set to <default>_<default>.<default> in the DSConfig.txt


Read more...

Environment

  • SAP Data Services 14.2.x
  • Microsoft SQL Server 2016 

Product

SAP Data Services 4.2

Keywords

DS, TC , KBA , EIM-DS-EXE , Job Execution , 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.