SAP HANA SQL Script INSERT
Welcome to the next tutorial explaining the usage of SAP HANA INSERT statement to insert new records into a HANA Table. This method can be applied on any table, no matter how it was created – Graphically ,by SQL CREATE or HDB Table
To start, we need the SQL editor. Click somewhere in the tree under the system so that the SQL button marked below becomes enabled. Press the button to bring up the SQL console.
As always, the blank console opens up.
INSERT Data into HANA Table
The syntax for SAP HANA INSERT statement is as below:
INSERT into VALUES (value1, value2, valueN);
Note: Always remember that refers to the table name prefixed with the schema name as well as there can be tables of the same name in different schemas.
Repeat this statement as many times as the number of rows you wish to add. As seen below, I am adding data to the CUST_REV_SQL table which is in the 0TEACHMEHANA schema. System object names like schema names, table names and field names should be wrapped in double quotes “ ” whereas as you can see below, data values that have character data types inserted MUST always be wrapped in single quotes ‘ ’ whereas number do not require any quotes at all.
As seen from the log below, there are no errors. This means that the data was inserted successfully.
Now to check if it worked
To confirm, right click on the table and click on data preview.
The raw data tab below confirms that the data is now present in the table.
And if you are wondering – Yes. It was that easy to do this. SQL for HANA is fairly simple if you understand what you are doing instead of just trying random experiments off the web. This concludes our second part of the SAP HANA customized table data load series. Be sure to check out the other two tutorials as well which are:
1. Loading flat files to SAP HANA in the Enterprise HANA section
2. Linking a CSV file to a HDBTable using HDBTI Configuration file (Recommended method) which is our next tutorial as well.
Help this website grow by sharing this document on social media by using the icons below.