Philip Mugglestone from the SAP HANA Academy details how to modify applications using River Definition Language in SAP HANA Studio.
Philip shows how to quickly add an element (in this case “age’) using RDL code complete.
Philip demonstrates how SAP River safeguards pre-existing data by not allowing a user to change the name of an entity that already contains data. Philip details a couple of methods to circumvent this safeguard and remove an entity’s existing data so that it’s name can be changed.
One method requires the user to access the entity’s table from the database schema and then truncate or delete the data from the table. However, this method is not very river-centric.
Philip shows a simpler way to remove data (especially if there are numerous rows) using an individual reset action that utilizes “apply delete ( ) to select * from (Entity Name)” as a line of code. Then when a user runs the reset action on a row of data in the data preview window, all of the entity’s data is removed.
This brief tutorial covers modifying applications and using reset actions to remove data.
View other tutorials on SAP River at the SAP HANA Academy.
SAP HANA Academy – over 500 free tutorial technical videos on using SAP HANA.
SAP HANA Academy