I found a couple things about Whenever that will 
present a problem with the way I program my code
so just wanted to let you know in case anyone was
going to try using this.

1.    I always put a DROP CURSOR <whatever> before
every single cursor loop.   This will generate a SQLError,
which I wouldn't want to see reported.

2.    Back in the "old" days I used to test for the existence
of a temp table before I did a DROP TABLE <table>.  Now
I simply set error message 2038 off and just drop the table.
Unfortunately the drop will generate a SQLError if the table
doesn't exist.   

So in order for me to use Whenever I would have to carefully 
change a few things about my code, which would be expected
and might be worth it to use this command.

Karen

Reply via email to