Skip to main content Skip to complementary content

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.

Example:  

SQL INSERT INTO [dbo].[Table_1] ([val]) VALUES (123) !EXECUTE_NON_SELECT_QUERY;

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!