Table operations in SCP HANA Service

[Dhanasupriya]

Hello All

I have explored more on SCP Hana Service and came up with this blog post.

My previous demo on SAP HANA Service: https://blogs.sap.com/2019/10/04/sap-ui5-app-on-sap-hana-cloud-trial-service/

Here I mentioned about Table Create, Insert, Select, Update and Delete operations using HANA SQL Scripting.

Make sure SAP HANA Service is activated in Neo Environment of SCP.



Open the service and check for roles and on below highlights.



Development Workbench:



Navigate to Editor and create the project structure based on our requirement.



I have created below Schema and a table for my demo.

Schema:



Table Create:



.xsaccess & .xsapp files



Make sure all the file changes are saved. Now browse to Catalog in Workbench



We should be able to see our created schema and table in Catalog.



Now start querying around this table:

INSERT:

INSERT INTO "ZSCHEMA_NEWQ"."SQLHANA.hanaproject.epmmodel.tableschemacreations::ZBOOKSFACTORY.booksTable" VALUES(1, 'SAP Fiori Certification Guide', 'SAP Fiori',2110.23);

Similarly inserted few more records and the output for insert statement is as follows:

In order to view the inserted records, We need to query Select.

SELECT:

SELECT * FROM "ZSCHEMA_NEWQ"."SQLHANA.hanaproject.epmmodel.tableschemacreations::ZBOOKSFACTORY.booksTable";



Operations and output on Select query:

COUNT: No of records in our table



COUNT: Based on Specific value



SUM :



SUM based on PERCENTAGE:



MIN & MAX:



GROUP BY:



ORDER BY: ascending & descending



TOP: 



UPDATE:



DELETE:



Will be going with more queries in future blog.

Please comment if any.

Thank you!!

BR//Dhanasupriya Sidagam