Bulk delete activity

[Randy Martin <Ra...@ds-iq.com>]

I have a task that needs to delete over a million rows using a key.  At first blush, I do not see any bulk or batch delete capabilities.  For instance, there are SQL dialects that support syntax like this:

DELETE x FROM schema.table x INNER JOIN filter.table f ON f.key = x.key;

Has anyone had a similar need?  How have you worked around it?

Thanks,
Randy