In more research in this problem I found that if the EXEC SQL OPEN cursor; command was not present that ecpg would just comment out the cusrsor declare statements.
Might I make a suggestion that the software designers make a rule to give some kind of notice at compile time (rather than only an error upon execution, which takes up a lot of peoples time ;) when situations like this are present. If this problem has already been resolved in subsequent versions GREAT! If not please pass along this suggestion to the appropriate people. Thanks again for your time and help! Lynn ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings