Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers