Closed
Solved
Stored Procedure
What rules in Pega if any other than Connect-SQL use the stored procedures?
This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.
What rules in Pega if any other than Connect-SQL use the stored procedures?
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
which other rules can directly use store procedure ?
Please let me know if anyone has any other suggestions
Accepted Solution
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
Hi Shekhar,
How to optimize "sppr_sys_reservequeueitem" stored procedure ??
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
Question
Question Solved
Question Solved
Question
Question
Question Solved
Question
Question
Discussion
Question
Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.