Connecting to MSSQL and MaxDB using SAP HANA Smart Data Access

Anil SAP Gupta
Updated on 22-Jun-2020 09:20:14

503 Views

In SAP HANA SPS07, following data sources are supported under Smart data access −Sybase ASESAP Sybase IQTeradata 13.0 or higherApache Hadoop 2.3MSSQL 11Oracle 12cWhen you click on the Adapter name while creating a new remote data source, you can see a list of all supported databases.You can also see in the above snapshot that all databases use the ODBC connection for a remote data sources.

C# Program to Perform Currency Conversion

Chandu yadav
Updated on 22-Jun-2020 09:19:32

4K+ Views

Let’s say you need to get the value of 10 dollars in INR.Firstly, set the variables: double usd, inr, val;Now set the dollars and convert it to INR.// how many dpllars usd = 10; // current value of US$ val = 69; inr = usd * val;Let us see the complete code −Example Live Demousing System; namespace Demo {    public class Program {       public static void Main(string[] args) {          Double usd, inr, val;          // how many dpllars          usd = 10;          // current value of US$          val = 69;          inr = usd * val;          Console.WriteLine("{0} Dollar = {1} INR", usd, inr);       }    } }Output10 Dollar = 690 INR

Connection Used in SAP HANA Smart Data Access

Anil SAP Gupta
Updated on 22-Jun-2020 09:19:06

498 Views

The remote system access communication is based on ODBC connection, and ODBC drivers for remote data sources − ASEODBC, IQODBC, and TDODBC. To create a remote data source, Right-click on Remote Sources → New Remote Source

Find Date Difference in C#

Samual Sam
Updated on 22-Jun-2020 09:18:41

124 Views

To find the difference between two dates in C#, you need to first set two dates to be compared using the DateTime object. We will use the DateTime class in C#.Date 1DateTime date1 = new DateTime(2018, 09, 15); Console.WriteLine("Date 1 : {0}", date1);Date 2DateTime date2 = new DateTime(2018, 09, 28); Console.WriteLine("Date 2 : {0}", date2);Now let us compare both the dates in C#. The following is an example to compare dates in C#.Example Live Demousing System; namespace Program {    class Demo {       static int Main() {          DateTime date1 = new DateTime(2018, 09, 15); ... Read More

Resetting a Customized Perspective in SAP HANA Studio

Anil SAP Gupta
Updated on 22-Jun-2020 09:18:26

490 Views

Yes, if you customize a perspective, and you want to reset it, you can select Reset PerspectiveHere you have an option that allows you to perform following options on a Perspective −Customize PerspectiveSave PerspectiveReset PerspectiveClose PerspectiveClose All Perspective

Print a Blank Line in C#

karthikeya Boyini
Updated on 22-Jun-2020 09:18:05

3K+ Views

To display a line in C#, use the Console.WriteLine().Under that set a blank line −Console.WriteLine(" ");The following is the code that displays a blank line −Example Live Demousing System; namespace Program {    public class Demo {       public static void Main(String[] args) {          Console.WriteLine(" ");          Console.WriteLine("Displayed a blank line above!");          Console.ReadLine();       }    } }OutputDisplayed a blank line above!

Print a Binary Triangle Using C#

Arjun Thakur
Updated on 22-Jun-2020 09:17:39

555 Views

Binary triangle is formed with 0s and 1s. To create one, you need to work around a nestes for loop and display 0s and 1s till the row entered.for (int i = 1; i

Print a Line on the Console Using C#

Chandu yadav
Updated on 22-Jun-2020 09:16:02

739 Views

To display a line, Console.Write() is used in C#.Console displays the result on the console. I have first set a string.string str = "Tom Hanks is an actor";Now displaying the above line.Console.WriteLine(str);The following is the complete code −Example Live Demousing System; namespace Program {    public class Demo {       public static void Main(String[] args) {          string str = "Tom Hanks is an actor";          Console.WriteLine("Displaying a line below");          Console.WriteLine(str);          Console.ReadLine();       }    } }OutputDisplaying a line below Tom Hanks is an actor

Start SAP HANA Studio with Immediate System Logon

SAP Expert
Updated on 22-Jun-2020 09:16:01

447 Views

Yes, to perform an immediate login you have to navigate to Installation directory and use the following start parameters −-h  Host name-n  Instance number-u  User nameUser name with special characters should be enclosed in double quotations (“”).Windows OShdbstudio.exe -h hanademo -n 03 -u HANAADMINhdbstudio.exe -h hanademo -n 03 -u "&hanatest"Linux OShdbstudio -h hana -n 03 –u HANAADMINhdbstudio -h hana -n 03 -u "&hana"Mac OSopen -a /Applications/sap/hdbstudio.app --args -h hana -n 03 -u HANAADMINopen -a /Applications/sap/hdbstudio.app --args -h hana -n 03 -u "&hana"Once you run above from command line, this will open HANA Studio. If you are prompted to enter password ... Read More

Print a Diamond Using Nested Loop in C#

Samual Sam
Updated on 22-Jun-2020 09:15:34

385 Views

With C#, you can easily display the following diamond shape.$ $$$ $$$$$ $$$$$$$ $$$$$$$$$ $$$$$$$ $$$$$ $$$ $To display a diamond shape, you need to focus on the following points −Number of rows Dollar sign to be displayed Empty spacesConsidering the above you can easily create the diamond shape as shown in the below code −Example Live Demousing System; namespace Program {    public class Demo {       public static void Main(String[] args) {          int i, j, r, d, e;          // rows = 5          r = 5;          // display dollar sign          d = 1;          // empty space          e = r - 1;          for (i = 1; i < r * 2; i++) {             // display empty space             for (j = 1; j

Advertisements