>What can I do to clear the cursor? I only found out when I tried to process a couple of hundred records in the DO WHILE and got a maximum numbers of cursors exceeded error.
>Thanks in advance.
>Martin

DROP VIEW only removes the definition from the DBC, it does not close the view. For that, you need to issue:

USE IN MyView