Question
Does 7.2.1 generate connector rules wizard for external database support clob datatype ?
I generated rules for an external database using the following wizard.
select Designer Studio > Integration > Connectors > Connector and Metadata wizard.
It was not able to create corresponding properties, activities for a column of clob datatype.
Does anyone have an alternative to get those properties created for clob. Looks like pega property type doesn't have clob type.
Thanks
SKR
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Can you provide more information with detailed steps.
I want to read CLOB column having more than 4K data. I have created text property and tried, it is errors in report definition.
How to create property to support CLOB data.
Hi Sandeep, I just added pyLargeColumn in Clob column property qualifier.
CLOB column property is configured in Report definition, when I run the RD, it shows below error.
We created a clob column in database and named it pzpvstream. This can be another approach
Hi Siva,
You wont be able to map the CLOB column to any property in Pega directly. However, you can try make using use of pyLargeColumn property qualifier introduced from Pega 7.2.1 for supporting CLOB.
A property qualifier can be a supplement information in a property that extends or restricts the given functionality. Property qualifier rules are instances of Rule-Obj-Property-Qualifier and stored in pr4_rule_property table.
When 'pyLargeColumn' qualifier is set on a property, it will be treated as a CLOB column when it is optimized.