Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
To add 5 hours in current time, we will use now() function from MySQL. The syntax is as follows −SELECT date_add(now(),interval some integer value hour);Now, I am applying the above query to add 5 hours to current time. The query is as follows −mysql> SELECT date_add(now(),interval 5 hour); The following is the output+---------------------------------+ | date_add(now(),interval 5 hour) | +---------------------------------+ | 2018-10-11 15:59:23 | +---------------------------------+ 1 row in set (0.00 sec)Look at the output above, it has increased the current time by 5 hours
In SAP HANA system, redeploy option is used to deploy the active objects in one of the following scenarios −If your runtime object gets corrupted or deleted, and you want to create it again.In case of runtime problems during object activation, and the object status is still active.
We can achieve this with the help of SHOW command. Firstly, I will use my database with the help of USE command −mysql> USE business; Database changedWe are in the “business” database now. After that, we can check that how many tables are available for this database. The query is as follows −mysql> SHOW tables; The following is the output+------------------------+ | Tables_in_business | +------------------------+ | addcolumntable | | autoincrement | | autoincrementtable | | bookindexes | | chardemo ... Read More
Redeploy option is available under SAP HANA Modeler Perspective −
This option is used for bulk activation of inactive objects in HANA repository. You have the following Activation modes −Stop activation incase of inconsistencies in affected objectsActivate and ignore the inconsistencies in affected objects
This option can be used to activate inactivate objects in SAP HANA Repository. When you click on Activate, you need to select HANA system.All inactive objects in your workplace are preselected for activation.You can remove or add objects for validation using these options −Add AllAddRemoveRemove All
SAP HANA also provides few of built-in tools which can be used for data provisioning in HANA database −Flat File Load (Import../Export.. option)Smart Data Streaming (This is available with HANA SPS09)Smart Data Access
Firstly, we need to create a table to understand the limit clause (as we want for SQL server).We will create a table with the help of CREATE command.Creating a tablemysql> CREATE table limitDemo -> ( -> id int, -> primary key(id) -> ); Query OK, 0 rows affected (0.58 sec)After that, let us insert records into the table −mysql> INSERT into limitDemo values(1); Query OK, 1 row affected (0.16 sec) mysql> INSERT into limitDemo values(2); Query OK, 1 row affected (0.12 sec) mysql> INSERT into limitDemo values(3); Query OK, 1 row affected (0.11 sec) mysql> INSERT into ... Read More
Following RFC connection types are available in SAP system −Connection Type 3 (ABAP Connection) This connection type is used to specify connection between ABAP systems. You need to mention the host name and IP address of source system and also the logon information. This is applicable for both type of RFCs, between ABAP systems and external calls to ABAP systems.Connection Type I (Internal Connections)This connection Type I indicates ABAP systems connected to the same database as current system. Type I entries are predefined and you can’t edit these entries.Connection Type L (Logical Destinations)The logical destination connection type indicates a physical destination. ... Read More
To understand whether a column exist or not, we have the following approaches −With the help of DESC commandUsing SHOW commandFirstly, we will create a table with columns −mysql> CREATE table ColumnExistDemo -> ( -> UniqueId int, -> UniqueName varchar(200), -> UniqueAddress varchar(200) -> ); Query OK, 0 rows affected (0.57 sec)In the first approach, we will get the entire column name with meaningful information. The syntax is as follows −DESC yourTableName; Let us apply the above query to check whether the column name exists or not. However, this approach is not good since it display all the columns.mysql> DESC ... Read More