Question

2
Replies
870
Views
gardz Member since 2014 1 post
PEGA
Posted: 4 years ago
Last activity: 4 years ago
Closed
Solved

External Database Class Mapping: Decimal values casted as numeric integers.

Hi there,

I am using the External Database Class Mapping tool to import data into a Pega class. PRPC 7.2 and Postgres

All of my decimal columns are being interpreted as integer property types.  Is there a specific database column type I should use to get Pega to intepret the values as Decimal and/ or Double. I have tried numeric(38,8) and double precision but all appear as Integer.

I'm aware I can change the property rule types manually. I'd like for PRPC to be able to recognize the columns correctly.

PRPC 7.2

PostgreSQL 9.3.9 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-11), 64-bit

Best,

Zach

***Updated by Moderator: Marissa. Removed user added #helpme and Ask the Expert group tags. Apologies for confusion, shouldn't have been an end-user option. Updated categories.***

Data Integration
Moderation Team has archived post
Share this page LinkedIn