Question
Morgan Stanley
IN
Last activity: 8 Apr 2017 15:48 EDT
Need a way to truncate set of tables linked to classes
I have a requirement to truncate a set of tables which have a corresponding classes which i fetch dynamically.
What is the best way to truncate the table linked to a class.
Do we have any OOTB activity/function/java API
***Updated by moderator: Lochan to add Categories***
Cognizant Technologies Solutions
GB
Hi
Truncate is a DDL command and I don't think you can fire DDL command from Pega (Although Pega internally fires it). I would recommend you can create a Connect-SQL and use the Delete operation and commit the changes in any activity / Utility as per your requirement.
Morgan Stanley
IN
Thanks Kapil.
Had the requirement been to truncate/delete from a single table one connect-sql would suffice..
However i have several tables whose name would be fetched at runtime and keeps changing.
Pegasystems Inc.
IN
Hi,
You may try to explore tools.getDatabase().executeRDB(sql) within an java steo of an activity.
Thanks,
Ujjwal
Cognizant Technologies Solutions
GB
Any way you have to pass the list of table to truncate the data. May i suggest following high level pointers.
1. You can refer the table name using a Pega class name if you have created the respective Data-Admin-DB-Table entry for the same.
2. You can refer PageName.pxObjclass to identify the table.
3. In a agent activity, do a page-new with the proper class name and on that step page call the Connect-SQL rule which is stored in a common class up the hierarchy like organisation level or framework layer.
Pegasystems Inc.
IN
Connect-Sql is able to access properties from top level page. Try using that to provide the table name. Not tried, byt worth trying.
-Saikat