Again from the ecpg docs. In http://www.postgresql.org/idocs/index.php?app-ecpg.html it mentions at the end of the page in the NOTES section:
"There is no EXEC SQL PREPARE statement."
I used it in creating a dynamic query and worked just fine. Actually ommiting it causes the program not to work :-(
Is the doc comment obsolete or is there something missing from the functionality of PREPARE?
cheers,
thalis
ps there is even an sqlca error (code -230) related to not having prepared a statement