Skip to Content
0
Nov 02, 2012 at 06:57 PM

Stored procedures for data maintenance in HANA Studio

211 Views

For a proof of concept, we are loading (and reloading!) data into table from local files. Data Services is NOT connect to our HANA box. To accelerate the process, it would be helpful to save the "DELETE FROM" or "TRUNCATE TABLE" into stored procedures. However, the stored procedures created under Content do not support INSERT/UPDATE/DELETE. Of course, I can always store the SQL as text files on my local PC, but it would be useful to store them centrally, where others could use them.

Any suggestions?