I am trying to use database procedure function to extract some data from a HANA view database.
Unfortunately, table name has dots (“.”), so it seems like AIMMS cannot parse it for SQL query properly. For example, the table name is something like xx.yy.zz/pp, where you can see some dots between xx, yy, and zz.
Can you help us to figure out proper syntax to write sql query with this type of name?
Best answer by MischaView original
I am not sure which database server you are using, but I tried this out on a MySQL database with a table called Mischa.Dot.Test. The following syntax works:
However, when searching on the Internet about this, using dots in table names is not considered as good practice. See the remarks made here, for example.