Posted: 29 Aug 2016 13:35 EDT Last activity: 13 Sep 2016 14:28 EDT
External Database Class Mapping: Decimal values casted as numeric integers.
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.
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
***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.***