Symptom
ODBC error related to implicit conversion from datatype 'UNITEXT' to 'CHAR' can be reported when executing a proxy procedure from SAP IQ 15.4 to SAP Adaptive Server Enterprise 15.x:
% dbisql -c 'uid=DBA;pwd=sql;eng=iqdemo2' -nogui
(DBA)> call priq('aaaaaaaa',1,'Mar 18 2015 10:21AM','S','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','a',1,'18 2015 10:21AM',1,1,1,null)
Could not execute statement.
Server 'srv15030': [Sybase][ODBC Driver][Adaptive Server
Enterprise]Implicit conversion from datatype 'UNITEXT' to 'CHAR' is not allowed. Use the CONVERT function to run this query.
SQLCODE=-660, ODBC 3 State="HY000"
Line 1, column 1
call priq('aaaaaaaa',1,'Mar 18 2015 10:21AM','S','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','a',1,'18 2015 10:21AM',1,1,1,null)
Press ENTER to continue...
Read more...
Environment
- SAP IQ 15.4 and later
Product
Keywords
KBA , BC-SYB-IQ , Sybase IQ , BC-SYB-SDK , SDK , 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.