Skip to Content
0

How do I execute multiple queries in a single odbc statement connection to SAP Hana?

Dec 07, 2017 at 01:51 PM

41

avatar image
Former Member

Hi

I want to execute multiple queries in an ODBC DSN Connection to SAP Hana DB. For example as below:

INSERT INTO Customers (CustomerName, Country) VALUES ('ABC Corp', 'India');
SELECT NAME, AGE FROM STUDENT;

I am using SQLExecDirect() to trigger the command and then SQLFetch() to fetch the resultset.

If I execute just one query it works fine.
I want the behavior to be the same as when I run queries on the SQL console in Hana Studio.

Please tell me how do I do it, if it is possible. If not possible then any suggestions for workaround would help.

Thanks
Suman

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers