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 34 of 58
Checking authoring schema job details in SAP HANA
Go to Job log → Current and you can see last job ran for changing authoring schema. You can double click on job type to open the details. In job details, you can see status of job details.
Read MoreView to find object dependency in SAP HANA
In SAP HANA system, you have one view available in SAP System schema named called as “OBJECT_DEPENDENCIES”
Read MoreChecking list of all available schema in SAP HANA
This can be checked using below SQL query and it will display all the available schema in HANA system.select distinct BASE_SCHEMA_NAME from "SYS"."OBJECT_DEPENDENCIES"
Read MoreChecking list of system schema in SAP HANA
This can be checked using below SQL query and it will display all system schema in HANA system.select distinct BASE_SCHEMA_NAME from "SYS"."OBJECT_DEPENDENCIES" where BASE_SCHEMA_NAME like ‘_SYS%’;
Read MoreChecking tables in a schema in SAP HANA database
You can check this detail using a SQL query in HANA. You have to pass schema name in Where condition. Try running below SQL query and this will show you list of all tables in a schema.Select distinct BASE_OBJECT_NAME from "SYS"."OBJECT_DEPENDENCIES" where BASE_SCHEMA_NAME like 'AF_HANA';AH_HANA- Schema name
Read MoreChecking all the list of fields for a table in SAP HANA
You can check this detail using a SQL query in HANA. You have to pass schema name in Where condition. Try running below SQL query −SELECT "DEPENDENT_OBJECT_NAME" from "SYS"."OBJECT_DEPENDENCIES" WHERE "BASE_SCHEMA_NAME" = 'AF_HANA' AND "BASE_OBJECT_NAME" = 'STORE' AND "DEPENDENT_OBJECT_NAME" like '%hier%';
Read MoreUsing Where-Used option in SAP HANA Modeling
With use of Where-used functionality you can easily find this information. Right click on object name → Where-Used
Read MoreDeleting inactive objects in SAP HANA
In SAP HANA, you can delete all inactive objects in workspace. In HANA Modeler Perspective → Delete Inactive Objects..You can also revert to last active version if exists.
Read MoreChecking transaction list waiting for lock-in SAP HANA
M_BLOCKED_TRANSACTIONS System View is used to provide a transaction list waiting for locks.You can run the following SQL query in the editor −SELECT * FROM M_BLOCKED_TRANSACTIONS;Details available under M_BLOCKED_TRANSACTIONS System View in SAP HANA
Read MorenStore 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 More