SAP Knowledge Base Article - Preview

2594965 - In SAP IQ 16.1, the load failed with conversion error when using NULL mask

Symptom

  • Upgrade from SAP IQ 16.0 SP11 to SAP IQ 16.1.
  • Load command fail with conversion error when the command contain NULL mask and masking value in the data file contain spaces.

    For example:

    LOAD TABLE test_tabe(col1 null('NULL', 'na') ,col2 null('na'))
    from  '/tmp/mydata.dat'
    delimited by '|' ROW delimited by '\n'
    QUOTES OFF ESCAPES OFF
    FORMAT BCP MESSAGE LOG '/tmp/mydata_msg.log'
    ROW LOG '/tmp/mydata_row.log';

  • The following error reported:
    • For a float data type:
      Cannot convert na  to Unknown TypeID (10)(16,8) (column col1)
      SQLCODE=-157, ODBC 3 State="07006"
    • For a tinyint data type:
      Cannot convert na         to tinyint(3) (column col2)
      SQLCODE=-157, ODBC 3 State="07006"

 


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

CR813485, NULL, , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.