Stored Procedure
What rules in Pega if any other than Connect-SQL use the stored procedures?
Pegasystems Inc.
IN
Hi,
Little confused about you query
But if you asking how to call store procedure in pega then answer is through connect-sql rule only
https://pdn.pega.com/node/8755/book_pdf
But if you looking for which all rules refer store procedure then there might be a lot of places
Thank You
Tata Consultancy Services
US
which other rules can directly use store procedure ?
Tata Consultancy Services
US
Please let me know if anyone has any other suggestions
Accepted Solution
Pegasystems Inc.
IN
Hi,
There are few store procedure, for example SP sppr_sys_reservequeueitem_b is used purely for agent processing.
There are different SP which are called by different rules based on their design
Not sure how much I have answered your query, but if I have got it wrong then please provide exact details that you looking for. I might be able to check for that
Thanks
CapGemini
IN
Hi Shekhar,
How to optimize "sppr_sys_reservequeueitem" stored procedure ??
Pegasystems Inc.
IN
Hi Rajesh,
Which version of prpc are you using?I guess we can do some modification in stored procedure query for 7.1.8 to optimize it.
Thanks,
Abhinav