Pega RDB Methods

RDB Methods:

Use Connect SQL rules and RDB methods only with an external database. Do not use Connect SQL rules or RDB methods for the PegaRULES database(s). Because not all properties in the PegaRULES databases are distinct database columns, use the Obj-Open and Obj-Save methods, not the RDB- methods, with the PegaRULES database to prevent loss of data.

Explain the RDB-List method?

The RDB-List method is used to retrieve rows from an external relational database and place the results as embedded pages in a specified step page of class Code-Pega-List.

This method references a Connect SQL rule instance and executes SQL statements stored in the Browse tab of that rule instance. The search can do anything we can specify in a SQL statement, such as a SELECT WHERE statement. Any constraints on the returned data are in the SQL.

Explain about RDB-Open method?

The RDB-Open method is used to retrieve a single row (a record) of data from an external relational database and add the retrieved data into a specified clipboard page as property names and values.

Use this method in conjunction with a Connect SQL rule that contains SQL SELECT or EXECUTE statements in the Open tab. Define the SQL statements so that the database returns exactly one row.

 Explain the RDB-Save method?

The RDB-Save method is used to save the contents of a clipboard page into a row of a relational database. The system saves the properties on the specified step page to the specified table in the database.

This method operates in conjunction with a Connect SQL rule that contains SQL statements such as INSERT, UPDATE, and CREATE statements on the Save tab.

Explain about RDB-Delete method?

The RDB-Delete method used to delete a row or rows from an external relational database using SQL.

This method operates in conjunction with an SQL statement in the Delete tab of a Connect SQL rule (Rule-Connect-SQL rule type) that contains the DELETE, TRUNCATE or DROP SQL statement.