Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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 More
To delete adjacent duplicate entries in an internal table, you can use the below command −DELETE ADJACENT DUPLICATE ENTRIES FROM [COMPARING ... |ALL FIELDS].Also, consider the below points −The system deletes all adjacent duplicate entries from the internal table . Entries are duplicate if they fulfill one of the following compare criteria:Without the COMPARING addition, the contents of the key fields of the table must be identical in both lines.If you use the addition COMPARING ... Read More
This can be achieved by creating an Indicator as per condition you are looking for- minimum drawn date time for POST-Test and Maximum drawn date time for PRE-Test. Once you create this indicator, it will show “Y” for the rows highlighted in yellow as per condition and “N” for other rows.=If ([Drawn date] = Min([Drawn date]) In ([Patient ABO/RN]) Where ([PrePost] = "POST") ) Or ([Drawn date] = Max([Drawn date]) In ([Patient ABO/RN]) Where ([PrePost] = "PRE") ) Then "Y" Else "N"You need to apply a filter for rows with indicator value- “Y”.Other option is you can create 3 variables as ... Read More
External libraries can be inserted using a file in a normal script tag. SAP UI5 also supports JQuery so it can be done by extending your heading from the controller.var s = document.createElement("script"); s.type = "text/javascript"; s.src = "http://domainname.com/somescript"; $("head").append(s);You can also add any external file using the following command −jQuery.sap.registerModulePath("ModuleName","http://Domainname.com"); jQuery.sap.require("ModuleName.jsFileName");You can navigate to the following path for more details−https://blogs.sap.com/2016/04/22/include-external-javascript-library-in-sapui5/
Try downloading nwrfcsdk library from sap and follow instructions mentioned in Readme to perform the installation. Use function Module like ENQUEUE_READ to perform remote call as below −#!/usr/bin/env ruby require 'sapnwrfc' require 'rubygems' conn = SAPNW::Base.rfc_connect(:client => '800', :sysnr => '01', :lang => 'EN', :ashost => 'hostname', ... Read More
Favicons are generally 16x16, but these days we can multi-resolution favicons also. To create a multi-resolution favicon, first, you need to create the highest-resolution version of the favicon, with an image of 256 × 256 px. Reduce the size of multiple resolutions and export, 16x16, 32x32.Open GIMP and from the File menu, open the 32x32 version of the Favicon. After that rightclick on the image and Open the other Favicon icons as layers,After that Export the image as Favicon, with extension .ico and add it to the website using the following code −
The novalidate attribute in HTML is used to signify that the form won’t get validated on submit. It is a Boolean attribute.You can try to run the following code to learn how to use novalidate attribute in HTML. In the following example, if you will add text in the field, then it won’t show an error.ExampleLive Demo HTML novalidate attribute Student Name Rank
ExampleFollowing is the required program −Live Demopublic class Tester { public static void main(String args[]) { int i = 0; do { i++; System.out.println(i); }while (true); } }The output will keep printing numbers in sequential order.
The toArray() method of the java.util.The ArrayList class returns an array containing all of the elements in this list in proper sequence (from first to the last element). This acts as a bridge between array-based and collection-based APIs.ExampleLive Demoimport java.util.ArrayList; public class ArrayListDemo { public static void main(String[] args) { ArrayList arrlist = new ArrayList(5); arrlist.add(20); arrlist.add(40); arrlist.add(10); arrlist.add(15); arrlist.add(25); for (Integer number : arrlist) { System.out.println("Number = " + number); ... Read More
Local variables are declared in methods, constructors, or blocks.Local variables are created when the method, constructor or block is entered and the variable will be destroyed once it exits the method, constructor, or block.Access modifiers cannot be used for local variables.Local variables are visible only within the declared method, constructor, or block.Local variables are implemented at stack level internally.There is no default value for local variables, so local variables should be declared and an initial value should be assigned before the first use.ExampleHere, age is a local variable. This is defined inside pupAge()method and its scope is limited to only ... Read More