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 for Me (Login required).

Search for additional results

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