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

[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