>how can you automate the zap command so that it will not prompt you for yes/no, instead it will go ahead and zap the table.? Help appreciated
>
SET SAFETY OFF
It's scoped to the DataSession it's issued in; IOW, if you use Private Datasessions, you'll want to issue it in each one.