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
How to map output of a function to an internal table in SAP ABAP using Gateway service
You need to just import the function so that it can be used. First, you need to have a ABAP structure which should map the structure of the output parameters.Exampledefine structure zza_enqtstat { entries_total : abap.int4; entries_peak : abap.int4; entries_actual : abap.int4; }Then map this newly created structure to a new entity in the gateway project. Now for the function ‘ENQUEUEGETSTAT’’ create a function import. Next step for you will be to redefine the method in DPC_EXT. Save you changes and it should work.
Read MoreSystem goes out of memory on establishing connection in a SAP-Delphi integrated project
When you are trying to release the object, make sure that you set the query object to null. When you set it to null, it will release the memory for sure. But the scope also plays a role, so make sure it is local to the procedure.Example Please find a sample snippet for reference myFunction := TSAPFunctions.Create; myFunction.Connection := FConnection; myFunction.RemoveAll; myQuery := mySAPFunction.Add('interface here'); myQuery.Call; myQuery := null; // will clear the memory Hope this helps!
Read MoreFetch max date and other field from the same row of a table grouped by other fields in SAP HANA
You have done partially correct but just missed one step further to get the desired result. The case where after grouping you need to pick one of the rows from the results, use rank number or rank function.You need to partition your data based on your requirement, then order them as per your requirement again then pick the desired row.ExampleFor e.g. partition your data by Item Number and Shop Id. Then order them in descending order of Date column. Then pick the row with row number as 1select date, Order_Number from (SELECT *, row_number() over ( partition by ...
Read MoreWhat is the difference between Ajax and jQuery-Ajax methods in jQuery?
Firstly, let’s go through what is Ajax and why it is used.AJAXAJAX stands for Asynchronous JavaScript and XML. AJAX is a new technique for creating better, faster, and more interactive web applications with the help of XML, HTML, CSS, and Java Script.It has the following points, which shows its importance.AJAX stands for Asynchronous JavaScript and XML. AJAX is a new technique for creating better, faster, and more interactive web applications with the help of XML, HTML, CSS, and Java Script.Ajax uses XHTML for content, CSS for presentation, along with Document Object Model and JavaScript for dynamic content display.With AJAX, when ...
Read MoreWhat is the difference between jQuery and AngularJS?
AngularJS is an open source web application framework. It was originally developed in 2009 by Misko Hevery and Adam Abrons. It is now maintained by Google. Its latest version is 1.4.3.The following are the features of AngularJS:AngularJS is a powerful JavaScript based development framework to create RICH Internet Application(RIA).AngularJS provides developers options to write client side application (using JavaScript) in a clean MVC(Model View Controller) way.Application written in AngularJS is cross-browser compliant. AngularJS automatically handles JavaScript code suitable for each browser.AngularJS is open source, completely free, and used by thousands of developers around the world. It is licensed under the ...
Read MoreModification not working for both internal table and control table in SAP ABAP
There seems to some mistake in your update modle. PFB the updated oneExampleMODULE update INPUT. MODIFY snctab INDEX ctrl-current_line. IF sy-subrc 0. APPEND snctab. ENDIF. ENDMODULE.
Read MoreIs Pivot available in SAP HANA
As per my understanding, for requirement #1 you can do something as below:SELECT Prod.Product_ID, JOB.Job_ID, SUM(J.Time) FROM TABLE_1 Prod INNER JOIN TABLE_2 Job ON Prod.Job_Id = Job.Job_ID GROUP BY Prod.Product_ID, Job.Job_IDSAP HANA does not support Pivot built-in as done by SQL but majorly it looks as a UI requirement. So what you can do is send the entire result to report and apply transformation in the report as per your requirement.
Read MoreOrder by a single field and display rest of the records in the same order with MySQL
Let us first create a table −mysql> create table DemoTable -> ( -> Id int, -> Name varchar(20) -> ); Query OK, 0 rows affected (0.82 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(201, 'Chris Brown'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable values(110, 'John Doe'); Query OK, 1 row affected (0.29 sec) mysql> insert into DemoTable values(101, 'Adam Smith'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(345, 'Carol Taylor'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(135, ...
Read MoreFind "greatest" between two columns and display with some records already null in MySql
Let us first create a table −mysql> create table DemoTable -> ( -> Value1 int, -> Value2 int -> ); Query OK, 0 rows affected (0.77 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(78, 89); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable values(19, null); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable values(null, 0); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable values(null, 95); Query OK, 1 row affected (0.15 sec)Display all records from the table using select statement −mysql> ...
Read MoreOrder records and delete n rows in MySQL
Let us first create a table −mysql> create table DemoTable -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> FirstName varchar(20) -> ); Query OK, 0 rows affected (0.65 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(FirstName) values('Chris'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable(FirstName) values('Adam'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable(FirstName) values('John'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable(FirstName) values('David'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable(FirstName) values('Mike'); Query OK, 1 ...
Read More