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

Report

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

Data Integration
Posted: 5 years ago
Posted: 23 May 2018 21:55 EDT
Shubham Shekhar (Shekhar_Shubham) Senior Solutions Engineer
Pegasystems Inc.
IN
Report

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
Posted: 5 years ago
Posted: 24 May 2018 8:38 EDT
Gyan Dahal (YangD245) Tata Consultancy Services
Tata Consultancy Services
US
Report

which other rules can directly use store procedure ?

Andrzej Radosh
Posted: 5 years ago
Posted: 13 Jun 2018 16:12 EDT
Gyan Dahal (YangD245) Tata Consultancy Services
Tata Consultancy Services
US
Report

Please let me know if anyone has any other suggestions

Accepted Solution

Posted: 5 years ago
Posted: 14 Jun 2018 2:45 EDT
Shubham Shekhar (Shekhar_Shubham) Senior Solutions Engineer
Pegasystems Inc.
IN
Report

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
Posted: 4 years ago
Posted: 6 Mar 2019 2:11 EST
Abhinav Gupta (Abhinav7) PEGA Manager, Technical Support - Platform Service Engineering
Pegasystems Inc.
IN
Report

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

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