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 Samual Sam
Page 110 of 151
How to call RFC in SAP using an ETL job?
You need to expose RFC as Web Service in SAP system. To create a Web Service, you have to open Transaction SE80 and this will open ABAP Workbench.You can define Web Service for −RFC Capable function modulesFunction GroupsBAPIsMessage InterfacesIn Web Service Wizard, enter the name and short text and select Function Module as Endpoint TypeWhen you navigate to configure service, you need to select SOAP profile from drop down as below −
Read MoreWhat happens when a negative value is inserted to UNSIGNED column in MySQL?
Error occurs when you set a negative value to UNSIGNED column in MySQL. For example, let us first create a table with an UNSIGNED field −mysql> create table UnsignedDemo -> ( -> Id int UNSIGNED -> ); Query OK, 0 rows affected (0.79 sec)The error is as follows whenever you insert negative value to column Id which is declared as UNSIGNED −mysql> INSERT INTO UnsignedDemo VALUES(-100); ERROR 1264 (22003): Out of range value for column 'Id' at row 1ExampleHowever, positive values work well for UNSIGNED. The same is shown in the example below. Insert some records in ...
Read MoreSelect and filter the records on month basis in a MySQL table?
You can use aggregate function SUM() with GROUP BY clause to achieve this.Let us create a table. The query to create a table is as follows −mysql> create table SelectPerMonthDemo -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> Price int, -> PurchaseDate datetime -> ); Query OK, 0 rows affected (2.34 sec)ExampleInsert some records in the table using insert command with one of them would be the date of purchase. The query is as follows −mysql> insert into SelectPerMonthDemo(Price, PurchaseDate) values(600, date_add(now(), interval -1 month)); Query OK, 1 row affected (0.42 sec) ...
Read MoreHow to Find the Largest Among Three Numbers using Python?
You can create a list of the three numbers and call the max method to find the largest among them. examplemy_list = [10, 12, 3] print(max(my_list))OutputThis will give the output −12ExampleIf you want to calculate it yourself, you can create a simple function likedef max_of_three(a, b, c): if a > b and a > c: return a elif b > c: return b else: return c print(max_of_three(10, 12, 3))OutputThis will give the output −12
Read MoreHow to make loops run faster using Python?
This is a language agnostic question. Loops are there in almost every language and the same principles apply everywhere. You need to realize that compilers do most heavy lifting when it comes to loop optimization, but you as a programmer also need to keep your loops optimized.It is important to realize that everything you put in a loop gets executed for every loop iteration. They key to optimizing loops is to minimize what they do. Even operations that appear to be very fast will take a long time if the repeated many times. Executing an operation that takes 1 microsecond ...
Read MoreFinding The Biggest Key In A Python Dictionary?
If you have a dict with string-integer mappings, you can use the max method on the dictionary's item pairs to get the largest value. exampled = { 'foo': 100, 'bar': 25, 'baz': 360 } print(max(k for k, v in d.items()))OutputThis will give the output −foofoo is largest in alphabetical order.
Read MoreHow to convert a spreadsheet to Python dictionary?
The easiest way to convert a spreadsheet to Python dictionary is to use an external library like pandas. This provides very helpful features like to_dict on excel objects. You can use these like −Examplefrom pandas import * xls = ExcelFile('my_file.xls') data = xls.parse(xls.sheet_names[0]) print(data.to_dict())OutputThis will give the output −{'id': 10, 'name': "John"}
Read MoreHow can we print multiple blank lines in python?
We can print multiple blank lines in python by using the character the number of times we need a blank line. For example, If you need 5 blank lines, you can use −Python 2.x: print "" Python 3.x: print("")You can use features like repetition operator in python to make this easier. For example,Python 2.x: print "" * 5 Python 3.x: print("" * 5)All of these commands will print 5 blank lines on the STDOUT.
Read MoreWhat are rvalues, lvalues, xvalues, glvalues, and prvalues in C++?
An lvalue has an address that your program can access. Examples of lvalue expressions include variable names, including const variables, array elements, function calls that return an lvalue reference, bit-fields, unions, and class members. A xvalue expression has no address but can be used to initialize an rvalue reference, which provides access to the expression. Examples include function calls that return an rvalue reference, the array subscript, etc. A glvalue (“generalized” lvalue) is an lvalue or an xvalue. An rvalue (so-called, historically, because rvalues could appear on the right-hand side of an assignment expression) is an xvalue, a temporary object ...
Read MoreWhat is the try block in Java?
A try/catch block is placed around the code that might generate an exception. Code within a try/catch block is referred to as protected code, and the syntax for using try/catch looks like the following –Syntaxtry { // Protected code } catch (ExceptionName e1) { // Catch block }The code which is prone to exceptions is placed in the try block. When an exception raised inside a try block, instead of terminating the program JVM stores the exception details in the exception stack and proceeds to the catch block.
Read More