Question
GM
US
Last activity: 16 Oct 2018 12:03 EDT
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.
OCBC Bank
SG
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.
Maantic Inc
US
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.
Maantic Inc
US
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.
Pegasystems Inc.
IN