Hi !
To extend the ODBC funtionality here ars some ideas:
1. Transactions.
That means, there is a SQL block something like that:
begin transaction
update table set field = 'this is a test' where field is ''
if sqlcode = 0 then
commit
else
rollback
2. Query Timeout parameter
This parameter defines the timeout in seconds, so the query not runs forever.
for example
querytimeout=60
the query terminates after 60 seconds.
This is a global ODBC parameter.
3. Additional Parameters in the Connection String:
Normaly the ODBC connection string looks like
DSN=mydb;Uid=myuser;Using=password;
Some DB systems allow to send additional Parameters with the connection string:
DSN=mydb;Uid=myuser;Using=password;Autocommit=0;clientfunctionpath='MYPATH';