Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0641

...

See Create Dataset with SQL.

Enable

Steps:

  1. D s config
    methodws

  2. Locate the following setting:

    Code Block
    "webapp.connectivity.customSQLQuery.enabled": true,Enable custom SQL Query
    SettingDescription
    enabledSet to true to enable the SQL pushdown feature. By default, this feature is enabled.
  3. D s config

  4. Locate the following setting:

    Code Block
    "webapp.connectivity.customSQLQuery.enableMultiStatement": false,
    SettingDescription
    enableMultiStatement

    When set to true, you can insert multi-line statements in your SQL pushdown queries. The default is false.

    Info

    NOTE: Use of multi-line SQL has limitations. See Create Dataset with SQL.

  5. Save the file. 
  6. As needed, you can configure the maximum permitted load time before timeout from the application. See Configure Application Limits.
  7. Restart the platform. See Start and Stop the Platform.

...