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 Abhinaya
Page 4 of 4
How can we import data from a text file having names of the columns in first row?
Sometimes, the input text file has the names of the columns in the first row and to import data from such kind of text file to MySQL table we need to use ‘IGNORE ROWS’ option. To illustrate it we are using the following example −ExampleFollowings are the comma separated values in A.txt file −Id, Name, Country, Salary 100, ”Ram”, ”INDIA”, 25000 101, ”Mohan”, ”INDIA”, 28000We want to import this data into the following file named employee3_tbl −mysql> Create table employee3_tbl(Id Int, Name Varchar(20), Country Varchar(20), Salary Int); Query OK, 0 rows affected (0.1 sec)Now, the transfer of data from a ...
Read MoreWhy MySQL uses the interval like 7 day and 2 hour instead of 7 days and 2 hours?
The reason behind this concept is that MySQL requires the unit keywords to be singular, regardless of the English grammar rules. If we will try to supply intervals like 7 days, 2 hours etc then MySQL will produce syntax error as follows −mysql> Select '2017-02-25 05:04:30' + INTERVAL 2 days; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'days' at line 1
Read MoreUsing BU, ZK code in SAP Macros
OK CODE – In SAP, an OK code is used for any functionality. The OK code is used to perform an action executed or will be executed (save, back, exit) etc. BU – This OK function is used to perform SAVE function in an MM01 transaction.ZK – This code is used to get the additional information. To find out a function of each button, you have to navigate to System -> Status -> Double click on GUI Status.
Read MoreCalling SAP Web Service to get data in Flash dashboard
You can also try hosting your Flash application on SAP box. Following approaches can be used:Using Transaction: SICF, you can change the default host’s default service to point to BSP application and then add crossdomain.xml file as MIME.You can also configure ICM to manage this and it sits between the outside world making HTTP, HTTPS, SMTP requests and the SAP System.Method 1:First, you need to create a BSP application -> Create -> MIME Object and import crossdomain.xml file and activate the application. Next is to execute transaction SIC with default settings -> Double click the default_host, go to the Default ...
Read MoreWhy the use of "using namespace std' considered bad practice?
C++ has a standard library that contains common functionality you use in building your applications like containers, algorithms, etc. If names used by these were out in the open, for example, if they defined a queue class globally, you'd never be able to use the same name again without conflicts. So they created a namespace, std to contain this change.The using namespace statement just means that in the scope it is present, make all the things under the std namespace available without having to prefix std:: before each of them.While this practice is okay for example code, pulling in the ...
Read MoreDebugging an Asynchronous RFC in SAP ABAP
In SAP system, an Asynchronous call (aRFC) of a remote-enabled function module specified in func using the RFC interface. The addition DESTINATION is used to specify a single destination in dest or use IN GROUP to specify a group of application servers. The latter supports parallel processing of multiple function modules.Check the below link which tells about Asynchronous RFC:https://help.sap.com/http.svc/rc/abapdocu_751_index_htm/7.51/en-US/abapcall_function_starting.htm#!ABAP_ADDITION_2@2@
Read MoreNot able to access SOAP Manager in SAP server
SAP server will not respond to request having IP but not the domain name. So you need to just add the domain to your host file. You can find the host files in host folder within drivers/etc folder. That should resolve your issue.
Read MoreDifference between using - "standard table of", "Hashed table of", or simply "table of" in SAP ABAP
“TYPE STANDARD TABLE OF “refers to the standard table. It refers to a normal internal table which can be accessed via table index or by key in case if you have a key defined over a table while sorting.“TYPE HASHED TABLE OF” refers to the generic hashed internal table. The table is created and data is stored using the hashing algorithm. The main advantage of the hashing algorithm is that accessing any part of the table is independent of the size of the table and hence an increase in the size of the table does not result in any delay ...
Read MoreHow to convert a byte array to a hex string in Java?
The printHexBinary() method of the DatatypeConverter class accepts a byte array and returns a hex string.Exampleimport javax.xml.bind.DatatypeConverter; public class ByteToHexString { public static void main(String args[]) { String sam = "Hello how are you how do you do"; byte[] byteArray = sam.getBytes(); String hex = DatatypeConverter.printHexBinary(byteArray); System.out.println(hex); } }Output48656C6C6F20686F772061726520796F7520686F7720646F20796F7520646F
Read More