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
Articles on Trending Technologies
Technical articles with clear explanations and examples
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 MoreWrite an example to find whether a given string is palindrome using recursion
Recursion is the process of repeating items in a self-similar way. In programming languages, if a program allows you to call a function inside the same function, then it is called a recursive call of the function.Following is an example to find palindrome of a given number using recursive function.Examplepublic class PalindromeRecursion { public static boolean isPalindrome(String str){ if(str.length() == 0 ||str.length()==1){ return true; } if(str.charAt(0) == str.charAt(str.length()-1)){ return isPalindrome(str.substring(1, str.length()-1)); } return false; ...
Read MoreHow to debug JShell in Java 9?
JShell is a REPL tool that allows snippets of code to be run without placing them in classes. This tool provides a way to evaluate declarations, statements, and expressions in Java and no need to create the main() method to test some parts of the code.The command "/debug" can be used to display debugging information for the JShell tool implementation. Once we type the "/debug" command, the debugging mode is on. After enabling the debug mode and type something like a simple addition, or a simple string, then it prints as below.Example-1jshell> /debug | Debugging on jshell> 5+3 Compiling: ...
Read More