Question
3
Replies
188
Views
Healthfirst
Healthfirst
US
Healthfirst
Posted: April 5, 2018
Last activity: April 14, 2018
Last activity: 14 Apr 2018 18:53 EDT
Closed
How to use and configure pyLargeColumn in property.
Hi,
Here my objective is to read external DB clob column using report definition.
Tried with text property, it is not supporting clob data more than 4k. How to use pyLargeColumn to extend the property size.
Pega version 7.2.1
Posted: 3 years ago
PEGA
Pegasystems Inc.
IN
Hi,
Show More
Hi,
- pyLargeColumn: This takes a boolean value dictating whether or not the property's contents will be large. If this value is true, then a CLOB column will be produced when SchemaBuilder.optimizeProperty is called
- pyColumnSize: On the two DB2 platforms, a size for a CLOB column is required. If optimizing a property (through SchemaBuilder) with pyLargeColumn as true on DB2, then this value will dictate the size to make the CLOB column. If this value is not set, then the default on DB2 will be 5M. This value is ignored for optimizing CLOB columns on any other platform, and the CLOB columns will not have an explicit size. If an insert attempts to exceed the max size of a CLOB column, an error will be thrown and the entry will not be saved.
When the above qualifiers have been set on the desired property, the call to SchemaBuilder.optimizeProperty will now optimzie that property using a CLOB column type.
Show Less
Posted: 3 years ago
Healthfirst
Healthfirst
US
Thank you chandrasekhar.
SchemaBuilder.optimizeProperty ? do you mean right click on the property and optimize or something else.
Can you please designer studio steps to do that.
Posted: 3 years ago
PEGA
Pegasystems Inc.
IN
Yes. By right click on the property and optimize.