SAP Knowledge Base Article - Preview

2185320 - Alter table to add identity column sets wrong attributes in syscolumns causing errors during bulk load - SAP ASE and JDBC/jConnect


  • Using "ALTER TABLE ADD column_name IDENTITY" command sets wrong attributes in the syscolumns system table
  • The following syscolumns fields are incorrect:
    • datatype = 108 (numericn), should be 63
    • offset = -11 (negative) and should be positive since the identity is fixed length
    • maxlen is off by one extra byte
  • When using ENABLE_BULK_LOAD in jConnect these errors can occur:
    • Server has encountered badly formatted rows from bulk copy. Could not locate the row position reserved for the insertion of the identity value.
    • Attempt to insert NULL value into column some_id, table some_table; column does not allow nulls.



  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0
  • jConnect 7.07 (versions might produce different errors)
  • JVM 1.7


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase SDK 15.7 ; Sybase Software Developer Kit 15.7


jConn, bcp, bulkload, Software Developer Kit, CR 786104, CR 786104, CR 786104, CR786122, CR#786122, 786122 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-SDK , SDK , Bug Filed

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.