how to run multiple sql statemnets using odbc API

You should specify in SQLexecute API the sql statements separated by semi colon - e.g. select * form nation;select * from region etc..

We support executing multiple queries as a batch and then reading results using the SQLMoreResults ODBC API.
NOTE - This is not supported for DML statements.