Thread: Ecpg : caught by global sqlca
Dear list, I have been porting a few embedded sql programs from DB2 to Postgres. While overall its a pretty painless exercise, I did get caught by the global sqlca thing. The piece of code went something like : EXEC SQL INCLUDE sqlca; main() { .. struct sqlca sqlca; .. (more code) } Now I found that any tests on sqlca.sqlcode within main() produced meaningless results. Eventually light dawned that sqlca looked like it was uninitialized, and that I need to have something like : EXEC SQL INCLUDE sqlca; struct sqlca sqlca; main() .. This strikes me as something that would be good to mention in the Ecpg doco - in bold type for people like me....:-) regards Mark
On Thu, Jan 30, 2003 at 09:59:14PM +1300, Mark Kirkwood wrote: > While overall its a pretty painless exercise, I did get caught by the > global sqlca thing. Actually some people are already working on a thread safe sqlca implementation which will change the whole situation. Michael -- Michael Meskes Email: Michael@Fam-Meskes.De ICQ: 179140304 Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!