SAP Knowledge Base Article - Preview

2492024 - IQ Load table command accepts wrong syntax and loading NULL for a DATE field silently when using Date function


  • After migration to SAP IQ 16 (SP11 PL06), the partial LOAD of some tables began silently inserting NULL on columns.
  • No truncation errors.
  • A valid date value such as "20170403" becomes NULL after loading.



  • SAP IQ 16 SP11 PL06 and above


SAP IQ 16.0 ; SAP IQ 16.1


load, DATE NULL, arbitrary inserts, IQ 16 SP11 PL06, CR808078, CR#808078, 808078, CR794823, CR#794823, 794823 , KBA , BC-SYB-IQ , Sybase IQ , 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.