Symptom
A non-unicode DB2 database is configured as the remote source for BW and an error like below is encountered:
"A database error occured.
The error message in the database was:
"internal error: Error opening the cursor for the remote database [IBM][CLI Driver][DB2/LINUXX8664] SQL0440N No authorized routine named "NVARCHAR" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884
for query "SELECT ..."
In order to fix the issue you are following the workaround provided in SAP Note 2625817 but unable to locate the $DIR_EXECUTABLE/config/property_db2.ini file.
Read more...
Environment
SAP HANA, platform edition 1.0
SAP HANA, platform edition 2.0
Smart Data Access
IBM Db2
Product
SAP HANA, platform edition all versions
Keywords
DB2, SDA, FUNC_to_nchar, FUNC_to_varchar, FUNC_to_nvarchar , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Known Error
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.