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
Articles by Ayyan
30 articles
Limit number of rows in Webi report in SAP BusinessObjects
When working with SAP BusinessObjects Web Intelligence (WebI) reports, you may need to limit the number of rows returned to improve performance and manage data volume effectively. There are several methods to control row limits depending on your data source and requirements. Universe-Level Row Limits If you are using a Universe as the data source, you can define row limits at the Universe level using the Universe Design Tool (UDT). Navigate to Universe Parameters → Controls to set the maximum size of the result set. This approach provides centralized ...
Read MoreExplanation about SAP ABAP Stack and JAVA Stack and role of Java Stack during ECC upgrade
Note that all SAP ERP modules run on SAP ABAP stack. SAP NetWeaver Application Server (ABAP Stack) is part of the SAP NetWeaver portfolio and represents the ABAP-based technical basis for many SAP products. It delivers technical frameworks, tools, repositories, and much more. When to Install Java Stack If you are planning to use SAP PI module then you should install Java Stack. Whenever you need something like Adobe Interactive Forms or NetWeaver Portal functionality that requires the Java Stack, it becomes necessary. You can go for an upgrade ...
Read MoreHandling errors in SAP GUI Scripting code
You can take reference from the GUI Scripting help section, and it can explain things in detail for error handling in SAP GUI Scripting. SAP GUI provides default property types for handling different message scenarios. If you want to perform the next step, stop, or abort a user step, you can use the following message type properties − ...
Read MoreABAP dump while creating an entry in SAP system using SAP JCO
This seems to be a problem at ABAP side and not Java side. This is an ABAP dump and you need to use Transaction code: ST22 on ABAP backend to check the functional module in SAP system. Identifying the ABAP Dump When encountering SAP JCO connection issues during entry creation, follow these steps to diagnose the problem − Navigate to transaction ST22 in your SAP system to access the dump analysis screen. This transaction provides detailed ...
Read MoreWhat are the latest operators added to JavaScript?
The latest operators added to JavaScript are spread operator and rest.Rest operatorWith rest parameter, you can represent number of arguments as an array. ES6 brought rest parameter to ease the work of developers. For arguments objects, rest parameters are indicated by three dots … and preceds a parameter.ExampleLet’s see the following code snippet to define rest parameter function addition(…numbers) { var res = 0; numbers.forEach(function (number) { res += number; ...
Read MoreHow to define getter and setter functions in JavaScript?
GetterWhen a property is accessed, the value gets through calling a function implicitly. The get keyword is used in JavaScript. An identifier, either a number or a string is allowed for set.SetterWhen a property is set, it implicitly call a function and the value is passed as an argument. With that the return value is set to the property itself. The set keyword is used in JavaScript. An identifier, either a number or a string is allowed for set.ExampleHere’s an example showing how to implement both getter and setter var ...
Read MoreJava Program to check whether one String is a rotation of another.
To find weather a string is rotation of another, concat the first string to itself twice and find weatherExamplepublic class Sample { public static void main(String args[]){ String str1 = "gala"; String str2 = "alag"; String s3 = str1+str1; if(s3.contains(str2)) { System.out.println("str1 is rotation of str2"); } else { System.out.println("str1 is not rotation of str2"); } } }
Read MoreWith JavaScript RegExp search a carriage return character.
To find carriage return character with JavaScript Regular Expression, use the following −\rExampleYou can try to run the following code to find a carriage return character. It returns the position where the carriage return (\r) character is found − JavaScript Regular Expression var myStr = "100% \r Responsive!"; var reg = /\r/; var match = myStr.search(reg); document.write(match);
Read MoreWhat kind of output is returned by MySQL scalar subquery? What are the restrictions on using it with MySQL query?
MySQL scalar subquery returns exactly one column value from one row and we can use it where a single column is permissible. Followings are the cases when scalar subqueries return value other than one row −Case1 − When it returns 0 rowsIn case if the subquery returns 0 rows then the value of scalar subquery expression would be NULL.Case2 − When it returns more than one rowsIn case if the subquery returns more than one row then, due to the property of scalar subquery, MySQL returns an error.It can be understood with the help of an example which uses the ...
Read MoreHow can we update MySQL table after padding a string with the values of the column?
We can update MySQL table after padding a string with the values of a column by using LPAD() or RPAD() function along with UPDATE clause. Following the example from ‘examination_btech’ table will make it clearer −ExampleSuppose if we want to append the values, in last, of column course with the string ‘(CSE)’ and want to update the table too then it can be done with the help of the following query −mysql> Update examination_btech set course = RPAD(Course, 11, '(CSE)'); Query OK, 10 rows affected (0.16 sec) mysql> Select * from examination_btech; +-----------+----------+-------------+ | RollNo | Name ...
Read More