You are here: Reference > Activity methods > Dataset-Execute

DataSet-Execute method

Use the DataSet-Execute method to perform data management operations on records defined by data set instances. The DataSet-Execute method's parameters are specific to the type of data set (database table, decision data store, HBase, HDFS, stream or Visual Business Director).

Decision Data Store Type - Method Parameters

This method operates on the specified step page and has the following parameters:

Parameter

Description

Data Set

Enter the name of the Data Set instance used to represent data in decision data stores.

Operation

Select the type of operation:

Insert records — Write records to the decision data store.
Read by keys — Read records in the decision data store.
Remove track — Remove a single track from the decision data store.
Truncate — Remove all records from the decision data store.
Browse partitions — Read partitions from the decision data store.

Depending on the type of operation, you can refine the way the operation takes place:

Insert records
- Specify time to live (in seconds): use this setting to specify the longevity of the records in the decision data store. This parameter accepts constant values (for example, 3600), property references of values calculated through expressions.
- Write single track: use this setting to write a single track represented by an embedded property. All other properties are ignored if you specify the single track.
Read by keys
- Result page: use this setting to define the result page. The result page consists of an existing Code-Pega-List page. You can use keywords (such as, Primary or StepPage), in which case the operation results in updating the page with the first records from the data set, something specially suited when working with a single value.
- Key values: use this setting to specify filtering through constant values or expressions.
Remove track: specify the embedded property that identifies the track to be removed by this operation. This operation can take a considerable amount of time to complete in environments with many decision nodes as it operates by removing the values from every single decision node.

Database Table Type - Method Parameters

This method operates on the specified step page and has the following parameters:

Parameter

Description

Data Set

Enter the name of the Data Set instance used to represent data in database tables.

Operation

Select the type of operation:

Save — Save records passed by a page or data transform in the database table.
Browse — Read records from the database table.
Browse by keys — Read records from the database table by a key.
Delete by keys — Remove records from the database table by a key.
Truncate — Remove all records from the database table.
Browse partitions — Read partitions from the database table.

Depending on the type of operation, you can refine the way the operation takes place:

Browse
- Maximum number of records to read: enter a value to define the threshold for stopping the browse operation. You can also define this value through an expression.
- Store results in: use this setting to define the result page. The result page consists of an existing Code-Pega-List page.
Browse by keys
- Define the key value.
- Store results in: define the clipboard page containing the results of this operation.
Delete by keys: define the key value to delete records by a key.

HBase Type - Method Parameters

This method operates on the specified step page and has the following parameters:

Parameter

Description

Data Set

Enter the name of the Data Set instance used to represent an HBase data source.

Operation

Select the type of operation:

Browse — Read all the records from the HBase data source.
Browse by keys — Read records from the HBase data source by a key.
Save — Save records passed by a page or data transform in the HBase data source.

Depending on the type of operation, you can refine the way the operation takes place:

Browse
- Maximum number of records to read: enter a value to define the threshold for stopping the browse operation. You can also define this value through an expression.
- Store results in: use this setting to define the result page. The result page consists of an existing Code-Pega-List page.
Browse by keys
- Define the key value.
- Store results in: define the clipboard page containing the results of this operation.
Save
- Save list of pages defined in named page: use this setting to save the list of pages from an existing Code-Pega-List page.

HDFS Type - Method Parameters

This method operates on the specified step page and has the following parameters:

Parameter

Description

Data Set

Enter the name of the Data Set instance used to represent an HDFS data source.

Operation

Select the type of operation:

Browse — Read all the records from the HDFS data source.
Save — Save records passed by a page or data transform in the HDFS data source.

Depending on the type of operation, you can refine the way the operation takes place:

Browse
- Maximum number of records to read: enter a value to define the threshold for stopping the browse operation. You can also define this value through an expression.
- Store results in: use this setting to define the result page. The result page consists of an existing Code-Pega-List page.
Save
- Save list of pages defined in named page: use this setting to save the list of pages from an existing Code-Pega-List page.

Stream Type - Method Parameters

This method operates on the specified step page and has the following parameters:

Parameter

Description

Data Set

Enter the name of the Data Set instance used to represent a stream data source.

Operation

Select the type of operation:

Browse — Read all the records from the stream data source.
Save — Save records passed by a page or data transform in the stream data source.
Truncate —Remove all records from the stream data source.

Depending on the type of operation, you can refine the way the operation takes place:

Browse
- Stop browsing after: enter a value to define the time threshold for stopping the browse operation.
- Maximum number of records to read: enter a value to define the threshold for stopping the browse operation. You can also define this value through an expression.
- Store results in: use this setting to define the result page. The result page consists of an existing Code-Pega-List page.
Save
- Save list of pages defined in named page: use this setting to save the list of pages from an existing Code-Pega-List page.

Visual Business Director Type - Method Parameters

This method operates on the specified step page and has the following parameters:

Parameter

Description

Data Set

Enter the name of the Data Set instance used to represent a VBD data source.

Operation

Select the type of operation:

Save — Save records passed by a page or data transform in the VBD data source. The data source is now visible in the data sources landing page, and you can use it when writing to VBD in interaction rules and decision data flows.
Truncate — Remove all records from the VBD data source.
Get statistics — Get the VBD data source statistics.

Internal Types - Method Parameters

You can save records passed by a page or data transform in the corresponding data store:

Adaptive Decision Manager: pxDecisionResults
Interaction History: pxInteractionHistory

Checking Method Status

This method updates the pxMethodStatus property. See How to test method results using a transition.

Data set rules
DNode management landing page

Methods and instructions by function

Open topic with navigation