Skip to Content
Aug 30, 2018 at 08:29 AM

How to extract data using DS from a HANA calculated view, receiving error.


I am trying to extract data from a HANA calculated view. When I try to run the extract I receive an error message that the SQL statement is incorrect. If I try to update the schema in the SQL transform I receive the following error:

ODBC Data source <HANA> error message for operation <OdbcDB::describeQuery>: [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 SQ syntax error ; incorrect syntax near "{": Line 4 col 42 (at pos 148)>. BODI-1130199

Here is the syntax I am using:


Any help would be greatly appreciated with why this is erroring out when passing in the required parameters.