DB Query to use stored procedures of a database

  1. On the DB Query Action page of a form, or on the Extended Properties page of a Data Access activity, click Configure.
    The Database Query page appears.
    Note By default, Tables is selected and all tables within the selected database are available on the Table list.
  2. Click Stored Procedures for Type.
  3. 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.
  4. Map the parameters (members / properties) using dynamic or static values.
    Note It is mandatory to specify values for all the columns/parameters.
  5. To configure the Resultset, do one of the following:
    • Consume a table control to the resultset.

    • To map the result set columns to table columns:

      1. Click Add Add for Resultset.

      2. Expand Resultset.

      3. Enter a name for the resultset column.

        Note Column name should be same as database column name.

      4. Consume the table column in the resultset value.

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

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