Executing non-SELECT statements
You can execute load scripts that do not start with an SQL SELECT statement, for example UPDATE, INSERT, EXEC, and WITH ... AS with the connectors in the Qlik ODBC Connector Package. This option needs to be enabled.
Enabling non-SELECT queries on SaaS editions of Qlik Sense
If you want to execute scripts that contain non-SELECT statements, you need to enable the setting Allow non-SELECT queries in the data connection dialog.
Enabling non-SELECT queries on Qlik Sense Enterprise on Windows and QlikView
To modify or load data by executing scripts that contain non-SELECT statements, the system administrator must first change the allow-nonselect-queries setting in the configuration file QvOdbcConnectorPackage.exe.config from false to true. The QvOdbcConnectorPackage.exe.config file is located in the following locations for installations of Qlik Sense and QlikView:
Qlik Sense Enterprise on Windows: ...\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage
QlikView: ...\Common Files\QlikTech\Custom Data\QvOdbcConnectorPackage
Setting allow-nonselect-queries to true allows you to load data using WITH ... AS or EXEC stored procedures.
Executing statements that do not return data
If you want to execute a query that contains statements such as UPDATE or INSERT, that do not return data, you can use an !EXECUTE_NON_SELECT_QUERY keyword at the end of the query. In this occasion the connector will execute the statement and then return an empty __skip_loading (string __empty_field) table instead.