Transaction: Begin, Lock

Hi,

I have two questions about transactions.
This is part of my C code.

EXEC SQL CONNECT TO ...
for (i=2; i<x: i++) {
strncpy(oid_c, entries[i].val, 10); /* get oid */
oid_rec = atoi(oid_c);
EXEC SQL BEGIN WORK;
EXEC SQL DELETE FROM phonebook
WHERE oid = :oid_rec;
EXEC SQL COMMIT WORK;
}
EXEC SQL DISCONNECT;

1. Why i get the following message when I run this code?
NOTICE: BeginTransactionBlock and not in default state

2. How should I lock the table phonebook during this transaction?

Thank you,

-Margarita
-------------------------------
Margarita Barvinok
System Administrator II
University of Michigan
Department of Biology
-------------------------------