Posted: 22 Mar 2017 15:29 EDT Last activity: 7 Apr 2017 4:43 EDT
How to update Database class mapping to use updated DDL.?
I have a class BNS-Data-Customer which maps to a DB table Customer. Now often changes occur in DDL of this table, e.g. adding /removing columns and I have to create/delete properties with same name and case of these DDL columns and also update External Mapping in class definition.
Does PRPC have a wizard to run and update this class mapping again with updated DDL..?
As per my understanding you have the class BNS-Data-Customer which maps to a DB table customer in the database. Now when you delete/add a new column in the customer table in the database with ALTER query then you need a mechanism in Pega to update the class Customer according to your columns available in the customer table after ALTER statement being executed.
If this is your requirement then it can't be done through Pega OOTB way, because it will have an issue with the Inheritance concept if you have child classes for your Customer class which might affect based on the removal of the columns in the parent table to the child table.
So when you add/remove the columns in the table using ALTER query at database and if you are sure that it doesn't have any child classes then you can manually map the new properties into the class Customer.