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.