some esql syntax questions

1 .) Why do I get esqlc: file "dbactions.ec", line 31: Syntax error on keyword or symbol ':'.(sqlnhost.y) when using the following expression ? EXEC SQL BEGIN DECLARE SECTION; char tab1[30]; EXEC SQL END DECLARE SECTION; [...] EXEC SQL LOCK TABLE :tab1 IN EXCLUSIVE MODE; 2.) What's wrong with the connect ? EXEC SQL CONNECT TO DEFAULT; esqlc: file "dbactions.ec", line 25: Syntax error on keyword or symbol 'connect'. (sqlhost.y) 3.) How can I do a COUNT(*) in esql/c ? EXEC SQL SELECT COUNT(*) FROM :tab1 INTO :n; fails... 4.) Can you recommend a good book on esql/c ? -- Michael Agbaglo | < > byteshif@cs.tu-berlin.de | DO IT IN PARIS ! \\ / | (m'thode pa'ifique) | | pgp: on demand | | |