Configuring the DataSet-Execute method for Database Table

You can automate data management operations on records that are defined by the Database Table data set by using the DataSet-Execute method. You can perform these operations programmatically, instead of doing them manually.

  1. Create an activity rule from the navigation panel, by clicking Records > Technical > Activity > Create, to start the DataSet-Execute method.
    For more information, see Activities - Completing the New or Save As form.
  2. Click the activity Steps tab.
  3. In the Method field, enter DataSet-Execute.
  4. In the Step page field, specify the step page on which the method operates, or leave this field blank to use the primary page of this activity.
  5. Optional: Enter a description for the method.
  6. Click the Arrow icon to the left of the Method field to expand the Method Parameters section.
  7. In the Data Set field, enter the name of the data set that is used to represent data in database tables.
  8. In the Operation list, select the type of operation. Depending on the type of operation, specify additional settings:
    • To specify the Save operation, go to step 9.
    • To specify the Browse operation, go to step 10.
    • To specify the Browse by keys operation, go to step 11.
    • To specify the Delete by keys operation, go to step 12.
    • To remove all records from the decision data store, choose Truncate.
  9. Save records passed by a page or data transform in the database table by specifying the Save operation by performing the following actions:
    • Select the Save list of pages defined in a named page check box to save the list of pages from an existing Code-Pega-List page.
    • Select the Only insert new records option or the Insert new and overwrite existing records option.
  10. Read records from the database table by specifying the Browse operation by performing the following actions:
    • In the Maximum number of records to read field, enter a value to define the threshold for stopping the browse operation. You can also define this value through an expression.
    • In the Store results in field, define the result page. The result page consists of an existing Code-Pega-List page.
  11. Read records from the database table by a key by specifying the Browse by keys operation by performing the following actions:
    • Select a key and enter the key value. You can also define the key value through an expression.
    • Optional: To define more than one key, click Add key.
    • In the Store results in field, define a clipboard page to contain the results of this operation.
  12. Remove records from the database table by a key by specifying the Delete by keys operation by performing the following actions:
    • Select a key and enter the key value. You can also define the key value through an expression.
    • Optional: To define more than one key, click Add key.