Question

3
Replies
828
Views
Ranjay_Singh Member since 2016 2 posts
Seniorlink
Posted: October 11, 2016
Last activity: October 13, 2016
Closed
Solved

Data Type of pzPVStream in MS SQL

Our DB vendor is MS SQL. We are planning to use a Database trigger to write a history to another table for compliance reasons. This DB table has a light weight BLOB column. We would use Pega way of writing history using a Rule Declare Trigger at some point in future but for now the quick way we want to adopt is use a DB trigger.

We want to set up a “after trigger” for this but MS SQL doesn’t allow an after trigger for a column with "image" data type. Since pzPVStream is defined as an "image" type, we are having this issue. My DBA suggested that we can use varbinary(max) as the data type for the BLOB column.

Before we begin to even explore that route, I wanted to check if anyone has done this before or come across this before? Will this data type be supported by Pega for this BLOB column?

Many thanks,

Ranjay

***Updated by Moderator: Marissa to update topic categories***

Data Integration
Moderation Team has archived post
Share this page LinkedIn