Load data without a SELECT statement

By default the connectors in the Qlik ODBC Connector Package do not execute load scripts that do not include an SQL SELECT statement. For that reason, statements such as UPDATE and INSERT cannot be used.

This default behavior can be changed by using the !EXECUTE_NON_SELECT_QUERY keyword at the end of the query to specify that the load script should be executed without a SELECT statement. To enable use of this keyword, 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: ...\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage

QlikView: ...\Common Files\QlikTech\Custom Data\QvOdbcConnectorPackage

When allow-nonselect-queries is set to true, the !EXECUTE_NON_SELECT_QUERY keyword can be used.

Example:  

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

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?