Set DirectDistinctSupport Parameters for the Loading script

based on: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/List_Box.htm

DirectConnectionMax

You can do asynchronous, parallel calls to the database by using the connection pooling capability. The load script syntax to set up the pooling capability is as follows:

SET DirectConnectionMax=2
CODE

DirectDistinctSupport

When a DIMENSION field value is selected in a QlikView object, a query is generated for the source database. SetDirectDistinctSupport to 'false' to generate GROUP BY instead of DISTINCT in queries for unique values.

SET DirectDistinctSupport='false'
CODE

DirectEnableSubquery

In high cardinality multi-table scenarios, it is possible to generate subqueries in the SQL query instead of generating a large IN clause. This is activated by settingDirectEnableSubqueryto'true'.
Note: When DirectEnableSubquery is enabled, you cannot load tables that are not inDirect Discovery mode.

SET DirectEnableSubquery='true'
CODE