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

 swetha guthula (swethag2)
Virtusa PVT Ltd

Virtusa PVT Ltd
IN
swethag2 Member since 2017 3 posts
Virtusa PVT Ltd
Posted: Jul 11, 2017
Last activity: Sep 6, 2017
Posted: 11 Jul 2017 8:09 EDT
Last activity: 6 Sep 2017 2:07 EDT
Closed
Solved

To revert RDB-Save Commit from PRPC

Hi ,

Is there any way to have Control of RDB-save Commit from PRPC.If there is any such settings please let me know.Does AutoDbSchemaChanges Dss will be helpful for this.

Please confirm.

To see attachments, please log in.
Data Integration

Accepted Solution

Posted: 7 years ago
Posted: 11 Jul 2017 8:50 EDT
Swarnendu Mukherjee (SwarnenduM)
BUPA
Swarnendu Mukherjee
BUPA
AU

Hi,

PRPC RDB operations are implemented as a single-statement transaction. RDB- methods immediately commit their changes to the database. However there is an alternative to implement this.

You can write a stored procedure to complete the insert/update operation. You can do the commit or rollback inside your stored procedure if any one of your operations fails. Invoke your stored procedure from a Connect-SQL.

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