DB Query to use stored procedures of a database
-
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.Tables is selected and all tables within the selected database are available on the Table list.By default,
- Click Stored Procedures for Type.
- 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.
-
Map the parameters (members / properties)
using dynamic or static values.
It is mandatory to specify values for all the columns/parameters.
-
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:
-
Click Add for Resultset.
-
Expand Resultset.
-
Enter a name for the resultset column.
Column name should be same as database column name. -
Consume the table column in the resultset value.
-
To add more columns to the resultset, repeat the preceding steps.
-
At runtime, the data in the stored procedure is retrieved and appears in the respective columns of the table. -