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
-
Economics & Finance
SAP HANA Articles
Page 35 of 58
nStore data in format of XML string in SAP HANA system
In older SAP HANA versions, no XML functions were provided. With HANA 2.0, these two functions are provided- XMLEXTRACT and XMLEXTRACTVALUE for extracting XML string in SAP HANA.Use of XMLEXTRACTXMLEXTRACT(, [, ])Syntax to use −Specifies an XML document of type CLOB, NCLOB, VARCHAR, or NVARCHAR.Specifies an XPath expression of type VARCHAR or NVARCHAR.Specifies a namespace declaration of type VARCHAR or NVARCHAR.DescriptionReturns the matching XML element. The return value is of type VARCHAR/NVARCHAR or CLOB/NCLOB depending on the type given for .If an XML element is empty (for example, ), then an empty result is returned. If an XML element ...
Read MoreIntegrate node.js with SAP HANA system
You can insert data into HANA database using node.js. You can also connect to SAP HANA database via JDBC driver.To connect via JDBC, you need to install JDBC driver ngdbc.jar. This driver is installed as part of SAP HANA client installation. Ngdbc.jar file is available at this location −C:\Program Files\sap\hdbclient\ on Windows platforms /usr/sap/hdbclient/ on Linux and UNIX platformsNext is to add ngdb.jar to the classpath and write a Java program to connect to a database and execute SQL command.jdbc:sap://myServer:30015/?autocommit=falseYou can also add one or more failover servers by adding additional hosts.ExampleFollowing is an example of connecting SAP HANA Server ...
Read MoreActivating an Attribute view in SAP HANA
This can be checked by looking at view name in a package. If there is a Grey diamond mark on the name it means View is not activated.
Read MoreAdding columns to output in an Attribute view in SAP HANA
This can be done in 2 waysYou can directly click on round circle in front of the column name in Details PaneYou can add a column to output by right click on the column and select → Add to OutputWhen you add a column to output pane, it is added in Output pane on the right side under columns list.
Read MoreDefining a primary key in an Attribute view in SAP HANA
This can be done by selecting column name from the list of columns under Output pane.
Read MoreDifferent License types in SAP HANA
HANA Support two types of license −Temporary License KeyPermanent License KeyTo check your system license, you have to select HANA system in Studio → right click → PropertiesThis will open Properties of your HANA system. Navigate to License option and there you can check license type in use −
Read MoreLearning SAP HANA Modeling and Administration
There are various tutorials that you can follow and you can get a fair idea about SAP HANA Concepts. We have various text and video tutorials published free on our website which is developed by experts. You can easily follow them as they provide step by step documentation for all key functions in HANA.https://www.tutorialspoint.com/sap_hana_administration/index.htmhttps://www.tutorialspoint.com/sap_hana/index.htmThere are various sites which provide HANA demo system access with nominal payment. Happy Learning…!!
Read MoreDifferent Package type in SAP HANA
In SAP HANA, packages are used to store design time repository objects under the Content folder in HANA Studio. You have two types of the package in HANA system:Structural This package only contains sub-packages and doesn’t store repository objects.Non-Structural This package stores both repository objects and sub-packages.
Read MoreGetting statistics details of SAP HANA system
_SYS_STATISTICS- This schema stores all system configuration and parameter details of HANA system.You can find this under Catalog folder in HANA Studio once you select relevant HANA system in System pane.
Read MoreChecking configuration of XS service in SAP HANA
This can be checked under Configuration tab in HANA Administration. You need to scroll down and there you can check details under xsengine.ini
Read More