incorrect syntax near "["

[Former Member]

HI,

I have a user defined table of name "TEST".

While do a select from SAP DI, got the following error:

SELECT * FROM [@TEST];

System.Runtime.InteropServices.COMException (0xFFFFF830): 1). [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Syntax error or access violation;257 sql syntax error: incorrect syntax near "[": line 1 col 15 (at pos 15)

This works well in Mysql Database, but got this problem with HANA Database.

Please advice, thanks!