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

 Amitha Jayawickrama (AmithaLanka) Virtusa Pvt. Ltd.
Virtusa Pvt. Ltd.
LK
AmithaLanka Member since 2012 3 posts
Virtusa Pvt. Ltd.
Posted: Oct 31, 2016
Last activity: Nov 1, 2016
Posted: 31 Oct 2016 1:41 EDT
Last activity: 1 Nov 2016 11:36 EDT
Closed

Exposing a history table column

Hi, we have a situation where we have to expose a column (pyMessageKey) in a History table and populate column with data. Table has close to 12 millions of records. We're using PRPC 6.3 SP1. What is the easiest way to achieve this? Thanks in advance.

To see attachments, please log in.
Data Integration

Posted: 7 years ago
Posted: 1 Nov 2016 11:35 EDT
Marissa Rogers (MarissaRogers) MOD Principal Knowledge Management Specialist
Pegasystems Inc.
US

Hi AmithaLanka,

I found this document that has some helpful information as well as in the comments.

How to expose a property as a database column with the Property Optimization tool

The comment from Sandeeproy-1 specifically:

For higher environments we can expose the column at the DB end and use the Column Populator (prpcUtils.sh or prpcUtils.bat) script provided by Pega to populate the exposed column from the BLOB.

Let me know if this doesn't work for you!

Marissa | Community Moderator | Pegasystems Inc.

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