Skip to main content

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.

Question

 Gyan Dahal (YangD245)
Tata Consultancy Services

Tata Consultancy Services
US
YangD245 Member since 2017 31 posts
Tata Consultancy Services
Posted: May 23, 2018
Last activity: Feb 17, 2021
Posted: 23 May 2018 11:42 EDT
Last activity: 17 Feb 2021 10:12 EST
Closed
Solved

Stored Procedure

What rules in Pega if any other than Connect-SQL use the stored procedures?

To see attachments, please log in.
Data Integration

Accepted Solution

Posted: 6 years ago
Posted: 14 Jun 2018 2:45 EDT
Shubham Shekhar (Shekhar_Shubham) Senior Solutions Engineer
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

To see attachments, please log in.
Posted: 6 years ago
Posted: 23 May 2018 21:55 EDT
Shubham Shekhar (Shekhar_Shubham) Senior Solutions Engineer
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

To see attachments, please log in.

Accepted Solution

Posted: 6 years ago
Posted: 14 Jun 2018 2:45 EDT
Shubham Shekhar (Shekhar_Shubham) Senior Solutions Engineer
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

To see attachments, please log in.
Posted: 5 years ago
Posted: 6 Mar 2019 2:11 EST
Abhinav Gupta (Abhinav7)
PEGA
Manager, Technical Support - Platform Service Engineering
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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

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.

Close Deprecation Notice