SAP Knowledge Base Article - Preview

2027479 - sp_iqindex - error SQLCODE=-638 when compound index has many columns – SAP IQ


When compound index on a table has many columns, sp_iqindex reports an error SQLCODE=-638:

There was an error reading the results of the SQL statement.
  The displayed results may be incorrect or incomplete.
  Right truncation of string data
  SQLCODE=-638, ODBC 3 State="22001"



  • SAP IQ 15.x
  • SAP IQ 16.x


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


compound index, SQLCODE, -638, STRING_RTRUNCATION, 128 bytes , KBA , BC-SYB-IQ , Sybase IQ , 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.