DB query to use stored procedures of a database

  1. On the DB query action dialog box of a form, click Configure.

    For a Data access activity, click Configure in the properties panel of the activity.

    The DBQuery dialog box is displayed.
  2. To specify the database connection string that holds the details of the relational database, on the Database connection list, select the global variable or click to manually enter the connection string.

    For a DAS activity, select the process or server variable or click to manually enter the connection string.

  3. On the Type list, select Stored procedures. (Default: Tables)
  4. On the Stored procedures list, select the database procedure to be used in the query. For example, to get the stored procedure for the jobs duration overrun query, select awsp_GetJobsDurationOverrun.
  5. Map the parameters (members / properties) using dynamic or static values.
    Note It is mandatory to specify values for all the columns/parameters.
  6. To configure the Return result set to, select either of the following:
    • Single control (default): Select a single control.

    • Multiple controls: To map the multiple controls, do the following:

      1. Click .

      2. Enter a name for the result set column.

        Note Column name should be same as database column name.

      3. Select a variable, control (form/global) or field on the Value list.

      4. Click Add.

      5. To add more columns to the result set, repeat the preceding steps.

  7. Click OK.

    The DB query action dialog box displays the Query.

  8. Click Save.

    At runtime, the data in the stored procedure is retrieved and appears in the respective columns of the table.