Close popover

Table of Contents

Configuring the DataSet-Execute method for Database Table

Version:

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 Creating an activity.
  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.
    • 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.
    • To define more than one key, click Add key.

  • About Data Set rules

    Data sets define collections of records, allowing you to set up instances that make use of data abstraction to represent data stored in different sources and formats. Depending on the type selected when creating a new instance, data sets represent Visual Business Director (VBD) data sources, data in database tables or data in decision data stores. Through the data management operations for each data set type, you can read, insert and remove records. Data sets are used on their own through data management operations, as part of combined data

  • Methods and instructions by function
  • Building expressions with the Expression Builder

    Author expressions using the Expression Builder by completing the following steps:

  • DataSet-Execute method

    Apply the DataSet-Execute method to perform data management operations on records that are defined by data set instances. By using the DataSet-Execute method, you can automate these operations and perform them programmatically instead of doing them manually. For example, you can automatically retrieve data from a data set every day at a certain hour and further process, analyze, or filter the data in a data flow.

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.