fdmAPI.executeQuery is for returning data from a SELECT satatement it will not perform DML operations. The command you will need is fdmAPI.executeDML. However, that said I'm not sure why you are crating a view in the event script, why not just run the SELECT statement against the original table. Also you do not want to be creating a view on every executiontion of your data rule
- Work with your DBA to create the view on the data.
- Use open interface adapter to temporarily stage the data from your view.
- Use Jython code in the BefImport event script to populate the open interface table and eventually pull data into data load workbench.
Note: If you're on FDMEE 18.104.22.168.100, you can pull data directly from the view using the universal data adapter instead of using the open interface adapter.
FDMEE Admin Guide 22.214.171.124.200 has info on both the open interface adapter and the universal data adapter.