Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Navigate to SAP HANA Modeler Perspective → Delivery Units. In the next window, click on the Create button and this will open below the window where you have to provide details about DU.As mentioned, the Delivery unit name should contain only capital letter alphabets (A-Z)(0-9) and _(underscore).
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.
We can allow multiple transactions with the help of START command and SAVEPOINT. Let us create a table with the help of CREATE command.Creating a tablemysql> CREATE table transactionDemo -> ( -> id int auto_increment, -> primary key(id) -> ); Query OK, 0 rows affected (0.76 sec)After that, I will begin a transaction with the help of START command −mysql> START TRANSACTION; Query OK, 0 rows affected (0.00 sec)After that, I am inserting the following record with the help of INSERT command −mysql> INSERT into transactionDemo values(); Query OK, 1 row affected (0.04 sec)We can display a record with the ... Read More
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 More
To maintain Vendor ID in SAP HANA, you need to navigate to Application Lifecycle management. −Start the SAP HANA Application Lifecycle ManagementThe SAP HANA Application Lifecycle Management is available on the SAP HANA XS Web server at the following URL −http://:80/sap/hana/xs/lmhttp:// bwhana:8002/sap/hana/xs/lmSelect “Administration” tab and click on “Change Vendor”
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)
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
The straight join in MySQL works like inner join or join. This means that it returns only the matching rows. Firstly, we need to understand Straight join in MySQL. For that, we need to create two tables and relate both the tables with foreign key constraints.Here is the first tablemysql> CREATE table ForeignTableDemo -> ( -> Id int, -> Name varchar(100), -> FK int -> ); Query OK, 0 rows affected (0.47 sec)Here is the second table −mysql> CREATE table PrimaryTableDemo -> ( -> FK int, -> Address varchar(100), -> primary key(FK) -> ); Query OK, 0 rows affected (0.47 ... Read More
Parent selectors are not present in CSS3. There is a proposed CSS4 selector, $, to do so, which could look like this (Selecting the li element) −ul $li ul.sub { ... }As an alternative, with jQuery, a one-liner you could make use of would be this. The: has() selector selects all elements that have one or more elements inside of them, that matches the specified selector. The tag defines a list item. The tag defines an unordered (bulleted) list.$('ul li:has(ul.sub)').addClass('has_sub');You could then style the li.has_sub in your CSS.
To add a role to user profile, open user profile in HANA Studio by navigating to Security folder. Go to Roles tab and click on “+” sign. In search window you have to search for this role − “sap.hana.xs.lm.roles::Administrator”