Question
SunLife
IN
Last activity: 25 Sep 2018 15:40 EDT
Update BLOB data
We need to update BLOB data for work objects residing in a table. The situation is the table is standalone without any class mapping. So, we are not able to use obj methods to update blob data for the existing work objects. We have thought of below approach -
- Use RDB-Open method to open work object ( Running “select pzpvstream from table where pzinskey =’XXXX’” from RDB method will open work object)
- Update required data on page.
- This is the part where we need help from PEGA. We need to use RDB-Save to update existing instance, and for that we need to build a query similar to the one that gets generated when Obj-Save/Commit is executed. If PEGA can provide us the functionality that converts data from a page into update query, then we can make it work.
Any help would be appreciated on this matter.
***Edited by Moderator Marissa to update SR Details***