Question
4
Replies
2124
Views
Posted: June 12, 2018
Last activity: June 12, 2018
Closed
Efficiently deleting multiple rows from a database table
I know that we're supposed to avoid RDB methods, but how would you efficiently do the operation below without it?
DELETE FROM RATINGS.CERT_PER_SCHED_NOTIFICATION where CERT_PER_ID = {PcsDelete.Per} |
Hi
The one way I see is, to do a Obj-Browse first on the where clause and get the key also.
Then do an Obj-Delete individually while iterating. Based on the design you can let pega take cake of committing to the database.
Is there anything specific you are looking for?
Regards
Bhavya