How to update BLOB Colum in DB Table using DB Script
We have a requirement where we have to add one extra column in DB table and have the value in that expose column but while opening a case Property value comes from the BLOB. So Exposed column value should exist in BLOB.
Is there any way using DB script that we can insert Exposed column value into the Blob Colum.
Tata Consultancy Services
IN
Hi @AASISHS6,
it is not possible,
Because when you write DB SQL to update the DB table data, it is a DB operation, and from DB it is not possible to open the blob (only read option is possible through UDF function) and edit the blob data. If that is allowed, then anyone who has DB access can update the blob from anywhere (that is, with any external application), and then it may impact the whole Pega application functionality. Also, it is not allowed due to security reasons. That is why Blob is owned by Pega and can be edited only through Pega operations or methods (i.e., through Obj-Save or OOTB activity).
Understanding Pega Blob and UDF
I hope this will help you.
Thanks,
Ashok