SAP Knowledge Base Article - Preview

2588295 - BCP does not preserve original table values, it always applies column default on target table - SDK for SAP ASE


  • A target table has a column default
  • A source table has values that are different from the target default
  • When a BCP is done from source to target
  • BCP will always apply the column default of the target
    • The end result is that data in source and target are different because of the BCP
  • Is there an option to suppress the default being applied, so the source table values are preserved across the BCP load?



  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
  • Open Client Client-Library
  • bcp


SAP Adaptive Server Enterprise 16.0


KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

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.