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 on Trending Technologies
Technical articles with clear explanations and examples
Enabling Web dispatcher in SAP HANA Studio
To enable SAP Web dispatcher, you have to change Instance Value 0 to 1 in sapwebdisp in SAP HANA Studio → Configuration tab. This will enable ICM Web dispatcher and it uses ICM Method to load or read the data from SAP HANA system. Note that this method of data load supports large volume of data.
Read MoreChecking status of Auto Documentation in SAP HANA
When you use the Auto documentation feature in SAP HANA, you can navigate to job log → Current tab and select Job-type Auto Documentation and double click.You can see details of Auto Documentation job details and Status- shows a green tick mark as successful.
Read MoreUsing Delivery unit in SAP HANA
In SAP HANA system, delivery units are used to transport repository objects between different HANA systems and is used by Lifecycle Manager LCM.To create a Delivery unit, you have to navigate to SAP HANA Modeler Perspective → Delivery Unit
Read MoreRole Required to use LCM in SAP HANA
In SAP HANA system, delivery units are used to transport repository objects between different HANA systems and is used by Lifecycle Manager LCM.To create a Delivery unit, you have to navigate to SAP HANA Modeler Perspective → Delivery Unit
Read MoreDifferent mapping options in SAP HANA while importing data from flat file
In SAP HANA, using file import you can load data to an existing table or can create a new table with the same column names as in the flat file.While using import wizard, you can define the mapping of columns. Following options are available −One to OneMap by NameUsing Map by Name option, you can map columns in CSV files to the columns in an existing table.
Read MoreWhat is ROW_NUMBER() in MySQL?
Row_NUMBER() included from MySQL version 8.0. It is a type of window function. This can be used to assign a sequence number for rows. To understand, create a table with the help of CREATE pcommand −Creating a tablemysql> CREATE table rowNumberDemo -> ( -> FirstName varchar(100) -> ); Query OK, 0 rows affected (0.92 sec)Inserting recordsmysql> INSERT into rowNumberDemo values('john'); Query OK, 1 row affected (0.17 sec) mysql> INSERT into rowNumberDemo values('john'); Query OK, 1 row affected (0.29 sec) mysql> INSERT into rowNumberDemo values('Bob'); Query OK, 1 row affected (0.13 sec) mysql> INSERT into rowNumberDemo values('Smith'); Query ...
Read MoreCreating a Delivery unit in SAP HANA using HANA Application Lifecycle Management
To create a delivery unit in SAP HANA, you have to navigate to SAP HANA Application Lifecycle Management.Next is to select PRODUCTS tab → Select Delivery Units tabTo create a new Delivery unit, click on the Create button. Enter the details as shown in the below window and click on Create.
Read MoreHow to convert an MySQL database characterset and collation to UTF-8?
Firstly, we will check which MySQL version is currently being used with the help of version() function −The query is as follows −mysql> SELECT version();The following is the output+-----------+ | version() | +-----------+ | 8.0.12 | +-----------+ 1 row in set (0.00 sec)As you can see in the above output, version 8.0.12 is being used. Now, we can check the current character encoding using the following syntax −SELECT CCSA.character_set_name FROM information_schema.`TABLES`T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name -> =T.table_collation AND T.table_schema = "yourDatabaseName" AND T.table_name = "yourTableName";Apply the above query −mysql> SELECT CCSA.character_set_name FROM information_schema.`TABLES`T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name ...
Read MoreHow to save time in milliseconds in MySQL?
To save time in milliseconds, we can use now(3) function because “milli 3” can be used for te same purpose. Firstly, I will create a table with the help of CREATE command −mysql> CREATE table MilliSecondDemo -> ( -> MyTimeInMillSec datetime(3) -> ); Query OK, 0 rows affected (0.70 sec)Inserting record into the table −mysql> INSERT into MilliSecondDemo values(now(3)); Query OK, 1 row affected (0.98 sec)Let us now view the table records −mysql> SELECT * from MilliSecondDemo; The following is the output+-------------------------+ | MyTimeInMillSec | +-------------------------+ | 2018-10-08 15:19:50.202 | +-------------------------+ 1 row in set (0.00 sec)
Read MoreHow to measure actual MySQL query time?
To measure actual MySQL query time, we can use the concept of profiling that must be set to 1 before executing the query.The order must be like this.Set profiling to 1 Then execute query Then show profilesNow, I am applying the above order to get the actual MySQL query time −mysql> SET profiling = 1; Query OK, 0 rows affected, 1 warning (0.00 sec)After that I am executing the following query −mysql> SELECT * from MilliSecondDemo; The following is the output+-------------------------+ | MyTimeInMillSec | +-------------------------+ | 2018-10-08 15:19:50.202 | +-------------------------+ 1 row ...
Read More