SAP MII - SQL query create temp table

[matica]

Hi guys,

is there a special syntax for creating a temp table? I have tried with local and global, everything works fine on HANA, but when I copy the query to SAP MII I get an error incorrect syntax. How should I use temp tables from MII?

Thanks!

Best regards,

Matic

[agentry_src · Accepted solution]

Don't copy the query to MII! Make a view, function, or most likely a stored procedure in HANA instead. Then simply execute the SP from MII. It is a bad practice to take the SQL script from the database and move it to MII. Much better performance to keep the more complicated scripts executing in their native habitat (the database). Depending on the size of the script, it will be a lot easier to maintain in HANA as well.

Regards, Mike