SAP HANA Articles - Page 12 of 58

Note that actual parameter of password policy section is maintained by indexserver.ini system file. It is recommended that password policy should be configured using Security editor of SAP HANA Studio however this can also be done by editing indexserver.ini file.

The last folder in SAP HANA Studio system navigation is Security and it has 3 subfolders inside it that define the system security policy and user management activities −SecurityUserRolesSecurity tab is used to manage Password Policy in HANA system −

To execute the table creation, click on the green arrow mark on the top right corner. You will get a confirmation as below that a column table has been created in Schema AA_HANA11 with name DEMO_TABLE −Statement 'create column table "AA_HANA11"."DEMO_TABLE"( "CUST ID" INTEGER null, "CUST NAME" VARCHAR (10) null)' successfully executed Affected Rows:0 in 5 ms 884 µs.

You can also convert a Column store table to a Row store table or a Row store table to Column store table using ALTER table command.Alter table "AA_HANA11"."DEMO_HANA" column;

Yes, it is possible to differentiate between both the table types.  When you go to schema and view the newly created table, you can see vertical lines in front of table name and it confirms that this is column store table.In below pic, you can see the difference between a Row store table and Column store table.

To check table definition, you need to right click on table name → Open Definition and this will open table structure under HANA database.

When the data is entered, you can see the data in this row-based table by going to the Data Preview option. To see the data, right-click on table name → Open Data PreviewWhen you run Data Preview of a table, you can see full data under the Raw Data tab. You can also view distinct values and perform some analysis.

To insert the data, you need to run the Insert statement in SQL editor. “Demo_HANA” is table name.Insert into Demo_HANA Values (1,'John'); Insert into Demo_HANA Values (2,'Anna'); Insert into Demo_HANA Values (3,'Jason'); Insert into Demo_HANA Values (4,'Nick');In SQL editor, add INSERT statements and execute (F8) as below −

Let us say you have executed the below create table SQL statement in HANA database −Create Table Demo_HANA ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) );To check the table in HANA database, navigate to AA_HANA11 schema and right click and refresh (F5). Navigate to “Table” folder and you can see new table with name Demo_HANA is created.

This is used to update versions of HANA Studio to newer versions. Studio Repository maintains the code to perform updates for HANA Studio.All the objects that you develop are maintained in Packages which are maintained under SAP HANA Repository. These packages are arranged in the form of hierarchy to make them easy to understand and logical.