Skip to Content
0
Aug 01, 2013 at 08:51 AM

update&delete TEMP TABLE IN HANA

2357 Views

Hello Experts,,i'm a new to SAP HANA

Can i update&delete temp table in hana ?

i can insert data into temp table in hana but i can not delete & update

------sample---------------------------------------------

DELETE FROM #FTISLAND WHERE "QTY" = '7'

UPDATE #FTISLAND
SET "QTY" = '11'

SAP DBTech JDBC: [7] (at 8): feature not supported: update statement for volatile table:
---------------------------------------------------------


Best regards and thanks to all of you that have helpfull answears, Thanks.