Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP HANA Articles
Page 27 of 58
Changing storage type of table in SAP HANA database
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;
Read MoreDevelopment Perspective in SAP HANA Studio
You have different ABAP and Java Perspectives to perform application development and to host applications on HANA system −ABAPABAP Connectivity and IntegrationABAP ProfilingJavaJava BrowsingJava EEJava Type HierarchyJava ScriptThese perspective can be opened by navigating to, navigate to Window option at the top → Perspective → Open Perspective → Other
Read MoreSQL statement to add a table as Virtual table in SAP HANA Smart Data Access
You can use following SQL statement for this −CREATE VIRTUAL TABLE ExampleCREATE VIRTUAL TABLE ABC.test_VT AT “ORCL_11G_WIN”.”NULL”.”OUTLN”.”Dept”;In this SQL statement, ABC.test_VT is Virtual table name“ORCL_11G_WIN”.”NULL”.”OUTLN”.”Dept”;- Remote location for creating Virtual table
Read MoreDetails maintained under Name server in SAP HANA
In SAP HANA system architecture, Name server is used to maintain topology of SAP HANA system. It details complete information about system landscape- all hosts in distributed environment, active components and services running on each component in a distributed system environment.Topology details of SAP HANA system is maintained.Name server holds the detail of each component and services running on each host and hence reduces the re-indexing time.
Read MoreAltering a database view in SAP HANA
You can alter the view, then we can use the Alter View command to alter the view.ExampleAlter view View_EmpInfo as Select Emp_Details.Id, Emp_Details.EmplName, EmpProj.Projname from Emp_Details inner join EmpProjInfo on Emp_Details.Id=EmpProjInfo.Id;We have applied ALTER command to update an existing view with name- View_EmpInfo which is applying Inner Join on two tables on Id column to create a database view.
Read MoreDropping a SAP HANA database view
You can drop a view using Drop command like we drop a table. You can perform all the operations that you perform on a table on the database view.Drop view "AA_HANA11"."DEMO_TEST";
Read MoreDifferent options under SAP HANA System Administration
Following tabs are available under SAP HANA Administration Console −OverviewLandscapeAlertsPerformanceVolumesConfigurationSystem InformationDiagnosis FilesTrace Configuration
Read MoreDifferent Audit trial targets in SAP HANA
In SAP HANA system, following audit trail targets are possible −Syslog (default) − Logging system of Linux Operating System.Database Table − Internal database table, user who has Audit admin or Audit operator system privilege he can only run select operation on this table.CSV text − This type of audit trail is only used for test purpose in a non-production environment.
Read MoreDifferent Audit level in an audit policy in SAP HANA
In an Audit policy, you can define different audit levels in SAP HANA −EMERGENCYCRITICALALERTWARNINGINFO
Read MoreSetting validity of a user in SAP HANA
At the time of user creation, you have an option to pass Valid From and Valid Until date.
Read More