Question

4
Replies
254
Views
ANUSHA CHERUKURI (ANUSHAC2)
Tech Mahindra
developer
Tech Mahindra
US
ANUSHAC2 Member since 2013 7 posts
Tech Mahindra
Posted: May 22, 2017
Last activity: June 8, 2017
Posted: 22 May 2017 9:35 EDT
Last activity: 8 Jun 2017 15:46 EDT
Closed

One of the decimal column in pega table defined wrongly

Hi Team,

In production one of the Work Table Decimal Column was defined wrongly.

Currently we have a table named ABC(work Table) where column named xyz defined as decimal(18,0)

here xyz was defined with scale of zero where inturn it is not saving decimal values in the column.

We have this column defined in production for almost 6 monthswhich do not have any decimal values in it,where as in blob same property is holding proper values with decimals.

here in blob we have value like 18.67 and in column it is getting saved as 18.

We are planning to change column definition from decimal(18,0) to decimal(12,2).Is there any wizard which can populate column values from blob to available column.

Please let us know is there any way other than deleting the column and creating the column to populate values.

Regards

Anusha

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.