Deleting data records by using SQL
Version:
Use the ExecuteRDB SQL API to delete records in your database through an activity, without requiring you to delete a data object in Pega Platform.
-
In the header of Dev Studio, click
. -
In the activity rule form, enter a label, select an application and the associated ruleset, and then click Create and open.
-
On the Steps tab, in the Label field, enter a unique identifier for the step.
-
In the Method list, select Java.
-
To the left of the Method list, click the Expand icon.
-
In the Method Parameters section, in the Java Source field, enter an ExecuteRDB method.
String delete = "delete from {class:" + <YourClassName> + "} where id = \\{fn concat('a', 'bc')\\}"; ClipboardPage listPage = tools.getThread().createPage("Code-Pega-List", "MyPage"); listPage.putString(".pxObjClass", <YourClassName>); listPage.putString(".pyMaxRecords", String.valueOf(0)); try{tools.getDatabase().executeRDB(delete , listPage)); } catch(Exception err) {oLog.infoForced("Exception occurred"); }
<YourClassName> is the name of the class into which you want to insert records. -
Click Save.
-
Start the insert of records into your internal database by running the activity.
Published September 11, 2020 - Updated January 21, 2021