1) Can anyone tell me what is the difference between Obj-operations and RDB-operations?

a)In terms of performance.

b)In terms of functionality

c)In terms of Limitation i.e. when to use what?

Obj- operations generate their own SQL while RDB- operations rely on the query written in Rule-Connect-SQL instances. Unless there is a need for custom SQL which cannot be solved by Obj- operations, RDB- operations are best avoided. That said, in situations where you need to insert using a select statement or delete multiple records based on a filter criteria, equivalent Obj- operations are currently not available and thus RDB- operations are useful.

2) exact difference between Obj-open vs Obj-open-by-handle?

a)In terms of performance.

b)In terms of functionality

c)In terms of Limitation i.e. when to use what?

Can you explain me with example to understand better?

Obj-Open opens the instance of a class based on values for all the key properties as defined in the class definition. Obj-Open-By-Handle opens the instance of a class based on just the pzInsKey of the record. If pzInskey is present (which means this is not an external class), being the primary key for the table, this query should perform faster since there would be an index for it.

Thank you Rajiv !!

From a COE/best practice point of view, RDB-* is generally not recommended.  We normally recommend our client to use Report Definition in Pega7 (if you don't need to write an activity, which is against guardrail).  RDB-* is normally used when you have to write a complex SQL or store proc, but then try to formulate the requirement and design so that you don't need to write complex SQL/store proc because maintenance will be difficult later.

Obj-Open-By-Handle uses primary key (e.g. pzInsKey) to open an instance.  Obj-Open allows you to use more than one WHERE clause but make sure columns are properly indexed before using this as there is a performance impact.

Hi Ajay,

In terms of funcationality both Obj operations and RDB can achive the requirement almost.

But performance wise, it's not recommended to use RDB methosd unless we are using external Database to connect and/or we are writing complex data base queries which are not possible with Obj methods.

Coming to difference between obj-open and Obj-Open-By-Handle:

As in the screenshot attached, both need to be passed parameter(s) to fetch record(s) from the Database. But Obj-Open-By-Handle can accept only a single parameter in general cases we pass pzInskey to fecth a record. Obj-open can accept more than one parameter infact a class which is having values to be passed can be mentioned. So, Obj-Open-By-Handle works on primary key only as there is a single unique row is returned after passing the primary key, but in obj-open we can pass any keys.

When the pzInsKey is available and when it is not available

Hi,

pzInsKey is a unique key for every rule in Pega.

Thanks,

Manikumar

Obj-Operations are performed on pega internal DB and no need to provide SQL script while performing these operations. Where as RDB-Operations are mostly used to interact with external DB, need to provide customized SQL script.

Obj-Open accepts any number of parameters where as Obj-Open-by-Handle expects only unique (pzInsKey) defined on class rule form.