How to read BLOB pzpvstream from our production database

General
, ,
1

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

2

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_stream
  • pr_read_int_from_stream
  • pr_read_from_stream

Each function has 3 input parameters:

  • property – String, the name of the property to extract
  • inskey – String, the pzinskey value of the record to read from
  • storage_stream – Byte array, the actual storage stream to read from

For example

SELECT pegadata.pr_read_int_from_stream(``'MaximumIncome','DMORG-DMSAMPLE-WORK A-3',``(SELECT pzpvstream FROM

pegadata.pc_work_dms WHERE pzinskey = 'DMORG-DMSAMPLE-WORK A-3')``)