Table operations in SCP HANA Service
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.
Navigate to Editor and create the project structure based on our requirement.
I have created below Schema and a table for my demo.
.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 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 * 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 based on PERCENTAGE:
MIN & MAX:
ORDER BY: ascending & descending
Will be going with more queries in future blog.
Please comment if any.