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 by Anjana
Page 2 of 4
Date value is not populating while using Native SQL in SAP to insert an Order
When inserting date values using Native SQL in SAP ABAP, you may encounter issues with date population. The primary issue is often related to variable binding syntax in the SQL statement. Solution You need to put a colon (:) before the variable to properly bind it in Native SQL. Here's the corrected syntax − EXEC SQL. INSERT INTO order VALUES('2', :sy-datum) ENDEXEC. The colon (:) is essential for host variable binding in Native SQL. Without it, the system treats sy-datum as a literal string rather than a variable reference. Alternative ...
Read MoreChanging Data Element of a column and showing description in Transaction SE16N
When working with transaction SE16N in SAP, you may need to change the data element of a column to display proper descriptions. This process involves updating the Data Dictionary (DDIC) element and ensuring the system recognizes the changes. Methods to Update Data Element Descriptions Method 1: Activate the Change The primary approach is to activate the change after modifying the data element. This ensures the system properly updates the column description in SE16N. Method 2: Force System Recognition An alternative method involves temporarily creating an error to force the system to refresh the element description ...
Read MoreAssigning debug roles to few users of SAP ABAP program
To assign debug roles to specific users in SAP ABAP programs, you need to ensure the role contains the proper authorization object S_DEVELOP with debug permissions. Debug Role Configuration The role that you have added should contain only one permission − Object S_DEVELOP ACTVT = 03 DEVCLASS = * OBJNAME = * OBJTYPE = DEBUG P_GROUP = * This authorization object S_DEVELOP controls access to development functions, where ACTVT = 03 represents the debug ...
Read MoreCheck if a string contains a number using Java.
To find whether a given string contains a number, convert it to a character array and find whether each character in the array is a digit using the isDigit() method of the Character class.Examplepublic class ContainsExample { public static void main(String args[]){ String sample = "krishna64"; char[] chars = sample.toCharArray(); StringBuilder sb = new StringBuilder(); for(char c : chars){ if(Character.isDigit(c)){ sb.append(c); } } System.out.println(sb); } }Output64
Read MoreWhy can't we define a static method in a Java interface?
From Java 8 onwards, static methods are allowed in Java interfaces.An interface can also have static helper methods from Java 8 onwards. public interface vehicle { default void print() { System.out.println("I am a vehicle!"); } static void blowHorn() { System.out.println("Blowing horn!!!"); } }Default Method ExampleCreate the following Java program using any editor of your choice in, say, C:\> JAVA.Java8Tester.javapublic class Java8Tester { public static void main(String args[]) { Vehicle vehicle = new Car(); vehicle.print(); } } interface Vehicle { default void print() { ...
Read MoreHow can we create MySQL views with column list?
As we know that while creating a view, providing the list of columns is optional. But if we are providing the name of the columns while creating the view then the number of names in the list of columns must be the same as the number of columns retrieved by the SELECT statement.ExampleThe following example will illustrate by creating the views with column list −mysql> Select * from student_detail; +-----------+-------------+------------+ | Studentid | StudentName | address | +-----------+-------------+------------+ | 100 | Gaurav | Delhi | | 101 | Raman ...
Read MoreHow can we delete an existing MySQL event permanently?
We need to use the DROP statement to delete an existing MySQL event permanently. To illustrate it we are deleting the event named testing_event as follows −Examplemysql> DROP EVENT testing_event; Query OK, 0 rows affected (0.00 sec)
Read MoreHow can I use MySQL IN() function to compare row constructors?
We can also use IN() function to compare row constructors. Consider the following example to make it clearer −mysql> Select (10,2) IN ((5,10),(10,2),(2,10),(100,100)); +--------------------------------------------+ | (10,2) IN ((5,10),(10,2),(2,10),(100,100)) | +--------------------------------------------+ | 1 | +--------------------------------------------+ 1 row in set (0.00 sec) mysql> Select (10,2) IN ((5,10),(2,10),(100,100)); +-------------------------------------+ | (10,2) IN ((5,10),(2,10),(100,100)) | +-------------------------------------+ | 0 | +-------------------------------------+ 1 row in set (0.00 sec)
Read MoreHow can we display MySQL bit values in printable form?
Actually, Bit values are returned as binary values but we can also display them in the printable form with the help of following −By adding 0We can display Bit values in printable form by adding 0 to them. Following the example from the bit_testing table can be used to understand it −mysql> Select bittest+0 from bit_testing; +-----------+ | bittest+0 | +-----------+ | 170 | | 5 | | 5 | +-----------+ 3 rows in set (0.00 sec)By using ...
Read MoreWhat MySQL returns if the search string is not in the list of strings provided as argument in FIELD() function?
Suppose if the search string is not in the list of strings provided as the arguments in FIELD() function then MySQL will return 0 as output.Examplemysql> Select FIELD('Ram','New','Delhi'); +----------------------------+ | FIELD('Ram','New','Delhi') | +----------------------------+ | 0 | +----------------------------+ 1 row in set (0.00 sec)
Read More