> How do I lock and unlock a table so that there can be no concurrent
> updates/inserts to that table ? I am using the C API.

Look at RESERVING clause of SET TRANSACTION command.
(or do the same using Transaction Parameter Buffer when using transaction API)

Ivan