Executing the Query - Developer Documentation
Skip to content

Executing the Query

Data Contextualization Query Service creates Job executions for Static Queries and Dynamic Queries. The Query execution process runs a Query plan and returns the results to the Query.

Executing a Static Query

A Static Query statement includes all of the information required to run the Query. When a user creates a static query in the Data Contextualization application, the query is executed automatically. To view the status of Static Query Execution, refer Query Execution Jobs.

Executing a Dynamic Query

A Dynamic Query has one or more parameters, the values of which must be provided before the Query Execution. After executing a Dynamic Query, the user can see the status of the execution in the "Jobs" user interface. The below section explains the steps to execute a Dynamic Query.

Procedure

To execute a Dynamic Query, follow these steps:

  1. In Data Contextualization, click "Queries" from the left navigation.
  2. Select the required Dynamic Query, click arrow under "Execution(s)" to view the execution page.

  3. Click "Execute" and enter the Variable data.

    Execute Query

  4. To rename the component number, enable the toggle button option.

  5. Click "Execute".

    Execute Query optional

Result

A Query is successfully executed.

Execution result

Last update: October 5, 2023

Except where otherwise noted, content on this site is licensed under the Development License Agreement.