Is it okay to update data in framework data table FSF_REF_COUNTRY ? should I do it using SQL(DML) ?
Yes, you can update data in FSF_REF_COUNTRY, but I’d treat it as framework reference/master data and avoid casual SQL DML for anything beyond controlled admin work. FSF_REF_COUNTRY is typically used as reference data (countries, codes, labels). Updating those rows is fine as long as you keep the structure and keys consistent with what the application expects.
The recommended way to change it is through Pega’s own data mechanisms, either
- using the Data Type UI (Records → Data → your reference data type) or
- save via standard activities (Savable Datapage, Obj-Save etc.).
You can use SQL DML for one‑time admin changes (for example, bulk updates as part of a controlled deployment), but that should be done carefully with full understanding of any foreign keys or lookups that depend on this table and with backups/tests so you don’t break reference lookups or caching.