Question
In pega 7.2.1, where we have the option "Create Dedicated Database Table" for datatype (datatable)
Hi,
In pega 7.2.1, where we have the option "Create Dedicated Database Table" for datatype (datatable)
Below statement is pega 7.3 help
When to use a dedicated table
If you do not select the Create Dedicated Database Table check box, instances of the classes created through this facility are stored in the PegaRULES database table named pr_other and are limited to 1,000 rows.
If your data table might eventually contain hundreds of rows, has high turnover, or might be moved to other systems, use a dedicated table.
Thank you Carissa
When I check in datatype, link displays to fix but it is not generating DDL.
Hi,
Creating the dedicated table using the OOTB feature is a good idea, but there is a slight problem with that. If you plan to deploy the table to the higher environment, you will need to have the DDL script anyways. You will not be able to create the table in the higher environment through the code import/export.
A dedicated database table will be generated when local data storage is configured. If you do not have the privileges needed then there will be an option to download the DDL so it can be applied manually.
https://pdn.pega.com/sites/pdn.pega.com/files/help_v721/procomhelpmain.htm#designer studio/data designer/data storage/data-storage-configuring-tsk.htm%3FTocPath%3DData%2520creation%2520and%2520management%7CData%2520type%2520management%7CConfiguring%2520local%2520data%2520storage%7C_____0