The following statement works fine in Hana Studio:
CREATE LOCAL TEMPORARY table #prc as (select '1' AS Test from dummy);SELECT * FROM #prc;DROP TABLE #prc
But when executed via the .NET Odbc Driver it doesn't work.
Looks like the driver doesn't like multiple queries.
When using the SqlClient (Micorsoft) it works.
Do i miss something?
Thanks for any enlightment.