SAP Knowledge Base Article - Preview

1613573 - SQL transform trims spaces when there is a VARCHAR datatype column in query– Data Services


Data Services trims all spaces when a CHAR column is converted to VARCHAR column.



  • Data Services
  • DB2 6.1
  • iSeries ODBC drivers 5.3
  • Linux Red Hat Enterprise 5.4


SAP Data Integrator XI R2 ; SAP Data Services 4.0 ; SAP Data Services XI 3.0 ; SAP Data Services XI 3.1 ; SAP Data Services XI 3.2


DI, DSXI, DS XI, BODI, BODS, 01567068, 1567068 , KBA , EIM-DS , Data Services , 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.