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.***
Accepted Solution
Pegasystems Inc.
US
Yes, I used double precision in Postgres to get the intended result.
Pegasystems Inc.
US
Zack,
Saw (from internal mesh post) you figured this out by using Double as column type, can you please confirm and close the question?
Thanks,
Kevin