How to read BLOB pzpvstream from our production database
How to read BLOB pzpvstream from our production database.
Column name pzpvstream need to read the data in text OR excel format.
Is there any way to query the blob column and get the property value.
Product Version 6.3
***Edited by Moderator Marissa to update General to Product; update Platform Capability tags***
If you have DB access of production ,
The pega database schemas provide 3 functions to read properties from the storage stream:
pr_read_decimal_from_streampr_read_int_from_streampr_read_from_streamEach function has 3 input parameters:
property– String, the name of the property to extractinskey– String, the pzinskey value of the record to read fromstorage_stream– Byte array, the actual storage stream to read fromFor example
SELECT pegadata.pr_read_int_from_stream('MaximumIncome','DMORG-DMSAMPLE-WORK A-3',(SELECT pzpvstream FROMpegadata.pc_work_dms WHERE pzinskey = 'DMORG-DMSAMPLE-WORK A-3'))