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 Monica Mona
Page 5 of 7
SAP interfaces throws an error message "Completion Code 2, Reason 2161, MQJMS2002”
As per my understanding, the only way to get the MQ jar files or the MQ C/C++ library files onto a system is by installing any of the below:Using WebSphere MQ product orUsing WebSphere MQ Client SupportPacsYou can find jar file under WebSphere MQ V7.0 Clients SupportPacks. The install files are commonly available under java/lib directory.You can try installing jar files from Fix Central. Go to Fix Central and enter "Java" in the Text search box.https://www-945.ibm.com/support/fixcentral/swg/identifyFixes?query.parent=ibm~WebSphere&query.product=ibm~WebSphere~WebSphere%20MQ&query.release=9.0&query.platform=AllThe name of the file to be downloaded is in this format:-[IBM|WS]-MQ-Install-Java-All.jar.For example, for MQ V9.0:9.0.0.0-IBM-MQ-Install-Java-All.jar.You have the following files that can be moved to ...
Read MoreWhat is length in Java Arrays?
Length is a filed in java, it gives the total number of the elements in a Java array. The length of an array is defined after the array was created.Integer[] myArray = {23, 93, 56, 92, 39}; System.out.println(myArray.length);
Read MoreHow many ways can get the instance of a Class class in Java?
You can create an object of the class named Class in two ways −Using new keyword as −Class obj = new Class();Using the forName() method of the class named Class.Class obj = Class.forName("DemoTest");
Read MoreMaking an SAP ABAP program to wait
You can use WAIT to hold the program for few seconds. Here is the syntaxSyntaxWAIT UP TO 36 SECONDSHowever, you need to be careful about using it. WAIT does an implicit commit. So you need to be sure that the commit does not corrupt the database. It also releases the work process.An alternative is to use below code −CALL FUNCTION 'ENQUE_SLEEP' EXPORTING seconds = 36.
Read MoreCan we create multiple database in SAP HANA system?
In SAP HANA, you don’t have a concept of creating multiple databases in one container. To create a separate container for your database objects, you can create the schema in HANA db.To create a schema, you can use below SQL query −CREATE SCHEMA schema nameYou can also define as owner name while defining a schema.CREATE SCHEMA [OWNED BY ]If it is not defined, the system takes the current user as the owner of the schema.
Read MoreWhat is the use of Custom Extractor in SAP R/3 system?
In order to extract data from tables, you need to follow steps:Create a View of the required table from where the data needs to be extracted or view over multiple joined tablesNavigate to Transaction SE11 and Select option 'View'. It will ask for a name, name it something like 'View_TableName'.Select which all the fields of the tables needs to be extracted and click on activateGo to Transaction RS02 and create a transaction extractor and name it something like 'Trans_TableName'Specify the position of the created extractor in the component hierarchy.If you want to provide descriptions, add it. Specify the view name ...
Read MoreHow can we find out the current transaction mode in MySQL?
We can run “SELECT @@AUTOCOMMIT” command to check the current transaction mode.mysql> Select @@AUTOCOMMIT; +--------------------+ | @@AUTOCOMMIT | +--------------------+ | 1 | +--------------------+ 1 row in set (0.05 sec) mysql> SET AUTOCOMMIT = 0; Query OK, 0 rows affected (0.00 sec) mysql> Select @@AUTOCOMMIT; +--------------------+ | @@AUTOCOMMIT | +--------------------+ | 0 | +--------------------+ 1 row in set (0.00 sec)
Read MoreHow can I use MySQL IF() function within SELECT statement?
It is quite possible to use MySQL IF() function within SELECT statement by providing the name of the column along with a condition as the first argument of IF() function. To understand it, consider the following data from table ‘Students’.mysql> Select * from Students; +----+-----------+-----------+----------+----------------+ | id | Name | Country | Language | Course | +----+-----------+-----------+----------+----------------+ | 1 | Francis | UK | English | Literature | | 2 | Rick | USA | English | History | ...
Read MoreHow can we reverse a MySQL string connected by the dash?
MySQL has function name REVERSE() with the help of which we can reverse the string. But suppose if we want to reverse the string connected by dash then by using REVERSE() function will not give appropriate result as shown in the following example:mysql> Select REVERSE('AB-CD-EF'); +---------------------+ | REVERSE('AB-CD-EF') | +---------------------+ | FE-DC-BA | +---------------------+ 1 row in set (0.00 sec)The appropriate result would be ‘EF-CD-AB’ and for getting such output we can use SUBSTRING_INDEX() function along with Instr() function. It is demonstrated as follows:mysql> Select CONCAT(SUBSTRING_INDEX('AB-CD-EF', '-', -1), '-', substr('AB-CD-EF', instr('AB-CD-EF', "-")+1, instr('AB-CD-EF', "-")), LEFT('AB-CD-EF', ...
Read MoreWhat are the similarities and differences between MySQL ORD() and ASCII() functions?
MySQL ORD() function returns the code for the leftmost character if that character is a multi-byte i.e. sequence of one or more bytes, with the help of the following formula(1st bytecode) + (2nd bytecode * 256) + (3rd bytecode * 256^2)On the other hand, ASCII() function returns the ASCII value of the leftmost character of a given string.The difference between them lies on the point that whether the leftmost character is a multi-byte character or not. If it is not a multi-byte character then both ORD() and ASCII() functions return similar results. Following example will demonstrate it.mysql> Select ORD('Tutorialspoint'); +-----------------------+ ...
Read More