SAP Knowledge Base Article - Preview

2775367 - BCP utility -b switch for 'batch size' ignores value larger than 65536 - SAP ASE & SDK for SAP ASE

Symptom

  • When using the BCP utility with -b switch for 'batch size'
  • Values larger than 65536 are ignored

  • The starting values of successfully sent rows are inconsistent when using a batch size > 65536
  • Outputs shows it starts with a batch of 131072 and does not show the message exactly every 65536 rows:

    bcp testdb..t1 in t1.dat -b75000 ...

    Starting copy...
    Batch successfully bulk-copied to the server.
    131072 rows sent to the server.
    196608 rows sent to the server.
    Batch successfully bulk-copied to the server.
    262144 rows sent to the server.
    327680 rows sent to the server.
    Batch successfully bulk-copied to the server.
    ...


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) - All versions
  • Software Developers Kit (SDK) for ASE - All versions
  • BCP utility

Product

SAP Adaptive Server Enterprise all versions ; Sybase SDK all versions

Keywords

BCP batchsize maximum batch size -b 65536 , CR#818917, #818917, CR#818918, #818918, CR#818919, #818919, CR#818920, #818920 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-SDK , SDK , 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.