Find Current Transaction Mode in MySQL

Monica Mona
Updated on 14-Feb-2020 06:10:57

650 Views

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)

Handle NO DATA SELECTED Exception in ABAP Function Module RSAQ_REMOTE_QUERY_CALL

Manikanth Mani
Updated on 14-Feb-2020 05:44:59

554 Views

As SAP provides flexible options that allow selection parameters easy to use. As you are using multiple parameters please note the following:Set KIND to “s” only for using select option. If you are using parameters, it should be “P”Instead of using EN, try using internal language “E”RSAQ_REMOTE_QUERY_FIELDLIST- this function module can be used to find the types as below −Use T-code SE37 and enter the FM name → Display

ABAP Dump While Creating an Entry in SAP System Using SAP JCO

Ayyan
Updated on 14-Feb-2020 05:43:45

459 Views

This seems to be a problem at ABAP side and not Java side. This is an ABAP dump and you need to useTransaction code: ST22 on ABAP backend to check functional module inSAP system.Once you get the exact details of ABAP dump you are getting, you need to edit the calling method to create an entry.

Extract Data from SAP HANA to Oracle Database

Paul Richard
Updated on 14-Feb-2020 05:38:34

946 Views

There is a number of ways you can achieve this. Here are few of the methods to do the same.a) There are many standard tools in SAP by use of which you can extract the data and also automate the whole process. With the use of an ETL tool, this can be achieved like SAP Data Services, OWB, etc.b) The other option is to write a code in ABAP to fetch the data from the database and the write into a format as per your requirement.c) You can also write a RFC or remote-enable function module which can be called ... Read More

Replace Multiple Occurrences by a Single Occurrence in SAP HANA

Kumar Varma
Updated on 14-Feb-2020 05:37:57

1K+ Views

The code you are using \1+ just removes consecutive occurrences only. You can use the below code.SELECT REPLACE_REGEXPR('(.)(?=.*\1)' IN '22331122' WITH '' OCCURRENCE ALL) FROM DUMMYThe output will come out to be “312”. This will remove all multiple occurrences and only last one will be kept.

Handling Exception and Using CX-ROOT in ABAP

Sai Nath
Updated on 14-Feb-2020 05:37:06

397 Views

It is not advisable to use CX_ROOT directly and you would require using one of its direct subclasses. Also, the propagation depends upon the exception subclass hierarchy.Subclasses of CX_STATIC_CHECK – these do not propagate automatically. You will need to do the handling yourself or there will be a syntax error in the program.Subclasses of CX_DYNAMIC_CHECK – these do not require any handling. But the program that does not handle the exception will be aborted with these subclasses.Subclasses of CX_NO_CHECK – These will get propagated automatically if the exception is not handled.

Using Breakpoint in SAP System

Jai Janardhan
Updated on 14-Feb-2020 05:36:30

231 Views

There is a problem with your code. Here is the correct syntaxSyntaxBREAK username.If you want to implement it for all the users you can just codeBREAK-POINT.

Concatenate 2 Strings in ABAP Without Using CONCATENATE Function

Moumita
Updated on 14-Feb-2020 05:32:25

3K+ Views

In ABAP you can use && sign to concatenate variables as belowDatahello TYPE string, world TYPE string, helloworld TYPE string. hello = 'hello'. world = 'world'. helloworld = hello && world.If you want to concatenate strings directly, you can usehelloworld = 'hello' && 'world'.If you want to keep space in between, you would require ` symbol as belowhelloworld = hello && ` and ` && world

Difference Between switchClass and toggleClass Methods in jQuery

Amit D
Updated on 14-Feb-2020 05:30:24

472 Views

The switchClass() is used to switch class from an element. Use it, to replace one class with another. Add jQuery UI library to the web page to use switchClass().ExampleYou can try to run the following code to learn how to work with switch class −Live Demo                          $(document).ready(function(){           $("a").click(function(){              $("a.active").removeClass("active");              $(this).addClass("active");            });          });             ... Read More

Use removeClass Method in jQuery

Amit D
Updated on 14-Feb-2020 05:28:00

132 Views

To add a class on click of anchor tag using jQuery, use the addClass() method. To remove a class, use the removeClass() method.ExampleYou can try to run the following code to learn how to remove a class using jQuery −Live Demo                          $(document).ready(function(){           $("a").click(function(){              $("a.active").removeClass("active");              $(this).addClass("active");            });          });                      .active {             font-size: 22px;            }                     One       Two       Click any of the link above and you can see the changes.    

Advertisements