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 on Trending Technologies
Technical articles with clear explanations and examples
Data Replication from SAP PO to SQL Server
It is important to note that SAP PO (Process Orchestration) is not a data source but a middleware − it does not store or contain business data itself. To replicate data to SQL Server, you extract data from the actual source system (such as SAP ERP) through SAP PO, and load it into SQL Server using a JDBC adapter. What Is SAP PI/PO? SAP Process Integration (PI), also known as SAP Process Orchestration (PO), enables cross-system communication and integration. It allows you to connect SAP and non-SAP systems based on different technologies like Java and SAP ABAP. It ...
Read MoreHow to call a function with argument list in Python?
The purpose of a function is to perform a specific task using code blocks. Functions save time by eliminating unnecessary copying and pasting of code. If you need to make a change, you only update the function in one place rather than searching through your entire program. This follows the DRY (Don't Repeat Yourself) principle in software development. Defining a Function in Python Python functions are created using the following syntax − def function_name(parameters): function body A function is defined using the def keyword followed by the function name and ...
Read MoreHow to expand tabs in string to multiple spaces in Python?
In Python, handling white spaces between strings is easy. Sometimes, we may want to add space in a string, but we are not sure exactly how much. Python provides different ways to manage this, and one useful method is the expandtabs() method. Using the expandtabs() Method The expandtabs() method in Python is used to replace tab characters (\t) in a string with spaces. It returns a new string where each \t is replaced with the number of spaces needed to reach the next tab stop. You can control how many spaces are used by passing a tabsize value ...
Read MoreCount the number of items in an array in MongoDB?
To count the number of items in an array in MongoDB, you can use the $size operator within the $project stage of an aggregation pipeline. The $size operator returns the number of elements in a specified array field. The syntax is − db.yourCollectionName.aggregate({ $project: { anyFieldName: { $size: "$yourArrayName" } } }).pretty(); Creating a Sample Collection To understand the above syntax, let us create a collection with documents. Each document contains a StudentMarks array with a different number of elements ? ...
Read MoreHow to select a single field in MongoDB?
You can select a single field in MongoDB using the projection parameter in the find() method. Projection lets you specify which fields to include or exclude in the query results. The syntax is − db.yourCollectionName.find( {"yourFieldName": yourValue}, {"yourSingleFieldName": 1, _id: 0} ); In the above syntax, "yourSingleFieldName": 1 means include this field in the result, and _id: 0 means exclude the _id field which MongoDB includes by default. Creating a Sample Collection To understand the above syntax, let us create a collection with documents ? db.singleFieldDemo.insertOne({"StudentName": "David", "StudentAge": 28}); ...
Read More“Structured” grouping query in MongoDB to display result with a new field displaying the count
For this, use $group in MongoDB with aggregate(). The $group stage groups input documents by the specified _id expression and for each distinct grouping, outputs a document. Structured grouping allows you to create complex grouping hierarchies and add calculated fields like counts to your results. Let us first create a collection with documents − > db.demo534.insertOne({_id:10, "ProductId":100, "ProductName":"Product-1"}); { "acknowledged" : true, "insertedId" : 10 } > db.demo534.insertOne({_id:11, "ProductId":100, "ProductName":"Product-2"}); { "acknowledged" : true, "insertedId" : 11 } > db.demo534.insertOne({_id:12, "ProductId":101, "ProductName":"Product-1"}); { "acknowledged" : true, "insertedId" : 12 } Display all documents from a ...
Read More“Toggle” query in MongoDB?
To implement a toggle query in MongoDB, you need to find the document first and then use the update operation to toggle the boolean field value. The toggle operation switches a boolean value from true to false or vice versa. Let us first create a collection with sample documents − > db.toggleDemo.insertOne({"CustomerName":"John Smith", "CustomerAge":28, "isMarried":true}); { "acknowledged" : true, "insertedId" : ObjectId("5cc7be138f9e6ff3eb0ce43b") } > db.toggleDemo.insertOne({"CustomerName":"David Miller", "CustomerAge":25, "isMarried":false}); { "acknowledged" : true, "insertedId" : ObjectId("5cc7be2e8f9e6ff3eb0ce43c") } Following is the query to display all ...
Read More\\nLoad and unload a table in SAP HANA using SQL query
In SAP HANA, it is possible to manually load and unload individual tables and table columns for memory management purposes. You can perform loading of table to precisely measure the total or "worst case" amount of memory used by a particular table. A table is unloaded from database to actively free up memory space. Basic Load and Unload Syntax You can use the following SQL queries to perform load/unload operations on tables − LOAD UNLOAD Loading a Table To load a specific ...
Read More\\nAnalyzing code coverage results in SAP Design Studio on top of HANA\\n
To analyze code coverage results in SAP Design Studio on top of HANA, you first need to establish a connection to your SAP HANA system and then visualize the data through Design Studio's reporting capabilities. Setting Up ODBC Connection To consume HANA views, you need to start by creating an ODBC connection to SAP HANA system through odbcad32.exe. This creates the necessary data source connection that Design Studio will use to access your HANA database. Connecting Design Studio to HANA The next step is to open SAP Design ...
Read More\\nHow to pass dynamic values on the fly to CDS in SAP ABAP\\n
While CDS (Core Data Services) views in SAP ABAP don't directly support passing dynamic values at runtime, there are several workarounds to achieve similar functionality depending on your specific use case. Limitations of Dynamic Values in CDS CDS views are compiled artifacts that cannot accept dynamic parameters like traditional ABAP methods. However, you can work around this limitation using the following approaches − Method 1: Using DCL (Data Control Language) with Authority Objects For authorization-based filtering, you need to declare and define the authority object in your DCL. This allows the system to automatically filter data ...
Read More