Symptom
You want to refresh SDA virtual table's definition on HANA database after the source table is changed.
However, the SQL command "ALTER VIRTUAL TABLE [<schema>.]<virtual_table_name> REFRESH DEFINITION" failed with error:
Could not execute 'ALTER VIRTUAL TABLE [<schema>.]<virtual_table_name> REFRESH DEFINITION'
SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "REFRESH": line 1 col 50 (at pos 50)
Read more...
Environment
SAP HANA 2.0
Product
SAP HANA, platform edition 2.0
Keywords
SDA, virtual table, refresh, definition , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , 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.