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

 Anup Kumar (AnupKumar)
Cognizant Technology Solutions
Anup Kumar
Cognizant Technology Solutions
IN
AnupKumar Member since 2013 1 post
Cognizant Technology Solutions
Posted: Aug 31, 2020
Last activity: Sep 1, 2020
Posted: 31 Aug 2020 14:48 EDT
Last activity: 1 Sep 2020 1:46 EDT
Closed

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***

To see attachments, please log in.
Pega Platform 6.3
Data Integration
Insurance

Posted: 4 years ago
Posted: 1 Sep 2020 1:46 EDT
Ashok Kumaresan (uashok93)
Areteans Tech
Associate Architect
Areteans Tech
AU

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'))

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