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 Qlik Sense SaaS
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.
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.
Exempel:
SQL INSERT INTO [dbo].[Table_1]
([val])
VALUES
(123) !EXECUTE_NON_SELECT_QUERY;