Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Configuring the DataSet-Execute method for Database Table

Updated on May 17, 2024

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 RecordsTechnicalActivityCreate, to start the DataSet-Execute method.
  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.
  • Previous topic Configuring the DataSet-Execute method for Adaptive Decision Manager
  • Next topic Configuring the DataSet-Execute method for Decision Data Store

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us