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