SAP Knowledge Base Article - Preview

2687974 - INSERT statement has failed with duplication error - SAP IQ 

Symptom



For data enclosed in quotes, trailing blanks are never trimmed on a varchar column. Therefore, a value of 'A' and 'A ' can insert as each values.
But,  INSERT statement which inserted these values into a varchar column of a primary key has failed with the duplication error.

Sample Error Message
 Tried to insert a duplicate value into a unique index dba.tableA.ASIQ_IDX_T1707_I2_HG on row 2.
 -- (slib/s_ohcins.cxx 964)
 SQLCODE=-1002003, ODBC 3 State="HY000"


            

         

           
              Read more...
           
        

      



Environment



   

    

  • SAP IQ All version
    • 








Product



  SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4





Keywords



   
 KBA , BC-SYB-IQ , Sybase IQ , How To 




          
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.