I am sorry if this question has been asked before but I am getting a
bit confused.


I want to call a few sql statements repeatedly periodically using the
api from a single thread. I want the changes reflected in the
database each time the statement is called.

Do I need to call the following api functions each time I want to
call one of the statements:-

// for inserts/updates & deletes
allocate_statement
start_tranaction
prepare_statement
descibe_bind
execute
commit_transaction
free_statement

// for selects
allocate_statement
start_tranaction
prepare_statement
descibe_bind
execute
isc_dsql_fetch
commit_transaction
free_statement

or can I do some statement initialisation on startup and cleanup on
killing the thread?

Will this work with more than one statement being called?

Also, Do I need to do a commit_transaction on selects?

Thanks in Advance!!!