Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
BO can connect to HANA in either of the following ways:OLAP SAP BICS ClientSAP BAPIOLAP SAP HANA ClientRelation DB Connectivity (JDBC/ODBC)OLAP SAP BICS (Business Intelligence Consumer Service) Client: This connection can be established either with the help of Information design tool or by using BI Server console. Naming BEx query is optional in this case. Therefore, solitaire BICS connectivity can be used to create reports on multiple BW cubes.SAP BAPI: This is the most prevalent way to connect BO server to BEx queries. For each BEx query one BAPI Connection is created. Therefore, if you have multiple BEx queries then ... Read More
Let us first create a table −mysql> create table DemoTable1597 -> ( -> Marks int -> ); Query OK, 0 rows affected (0.69 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1597 values(45); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable1597 values(59); Query OK, 1 row affected (0.24 sec) mysql> insert into DemoTable1597 values(43); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable1597 values(85); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable1597 values(89); Query OK, 1 row affected (0.12 sec)Display all records from the table ... Read More
The rank is a MySQL reserved word defined in MySQL version 8.0.2. Therefore, you cannot use rank as a column name. You need to use backticks around the rank.Let us first check the MySQL version we are working on. Here, I am using MySQL version 8.0.12 −mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.12 | +-----------+ 1 row in set (0.00 sec)The issues by using “rank” as column name are as follows −mysql> create table DemoTable1596 -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> StudentName varchar(20), -> rank int ... Read More
For this, use Regular Expression in MySQL as in the below syntax −select * from yourTableName where yourColumnName regexp '\land[\land ]+[ ]+[\land ]+$';The above query will work when the two words are separated by a space. Let us first create a table −mysql> create table DemoTable1412 -> ( -> Name varchar(40) -> ); Query OK, 0 rows affected (0.52 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1412 values('John Adam Carol'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable1412 values('Mike Sam'); Query OK, 1 row affected (0.15 sec) mysql> insert ... Read More
To call stored procedures within a stored procedure, the syntax is as follows −If yourInputValue > 100 then call yourProcedureName1(); else call yourProcedureName2(); end If ; ENDLet us implement the above syntax. In order to implement the above concept, let us create a stored procedure −mysql> delimiter // mysql> create procedure Hello_Stored_Procedure() -> BEGIN -> select 'Hello World!!!'; -> END -> // Query OK, 0 rows affected (0.18 sec)The query to create the second stored procedure is as follows −mysql> create procedure Hi_Stored_Procedure() -> BEGIN -> ... Read More
To get the specified members of the current Type, the code is as follows −Example Live Demousing System; using System.Reflection; public class Demo { public static void Main() { Type type = typeof(Subject); try { FieldInfo fieldInfo = type.GetField("SubName"); MemberInfo[] info = type.GetMember("SubName"); Console.Write("Members = "); for (int i = 0; i < info.Length; i++) Console.WriteLine(" {0}", info[i]); Console.WriteLine("FieldInfo = {0}", fieldInfo); } catch ... Read More
There are many middleware tools that work as middleware for integrating different applications. There exists a vast variety of them but choosing a correct one is based on the applications being integrated.For integrating the third-party application with either SAP or Navision, you can use Apache Camel. Also, SAP provides a framework - SAP PI - SAP NetWeaver Process Integration.Lately, SAP Business One has emerged as the preferred choice for integration of third-party applications with SAP. It is highly preferred by developers as it provides vast options for handling various use cases. Its working is based on either of the two ... Read More
For this, use REGEXP_REPLACE(). Let us first create a table −mysql> create table DemoTable1595 -> ( -> StudentCode varchar(50) -> ); Query OK, 0 rows affected (0.44 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1595 values('200 John'); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable1595 values('101 Carol/400 Taylor'); Query OK, 1 row affected (0.72 sec) mysql> insert into DemoTable1595 values('101 302 405 Sam/9870'); Query OK, 1 row affected (0.28 sec)Display all records from the table using select statement −mysql> select * from DemoTable1595;This will produce the following output −+----------------------+ ... Read More
There are various (not many as for JAVA and others) possible ways to achieve the task. One way is to go for existing remote function calls library for establishing a connection. There are free to use wrappers written around RFC to serve the task.Another library available for the same and mostly used is ERPConnect. It is easy to use and provides an easy mechanism to call BAPI, functions and table calls.But the best way to go for use is web services but for that, you have to be on ERP5.0 or higher. In such case, no .NET connector is required ... Read More
To select the nth highest value in MySQL, following is the syntax −select distinct(yourColumnName) from yourTableName order by yourColumnName DESC limit (NthValue-1), 1;Let us first create a table −mysql> create table DemoTable1594 -> ( -> Marks int -> ); Query OK, 0 rows affected (0.49 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1594 values(76); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable1594 values(95); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable1594 values(56); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable1594 values(96); Query OK, ... Read More