Marking records as write-protected

To prevent a record from being overwritten when the reference data is updated, flag it as being write-protected. To do this, use SQL commands to set the value in the WRITE_PROTECTED column to Y. Because the RDU does not modify or delete write-protected records, they must be maintained manually.

To undo the write protection, set the value to N. To force write-protected records to be updated, specifying the Reference Data Utility command command with the -locked parameter (see Forcing write-protected records to be updated). For examples, see Table 1.

UPDATE schema.DNI_COUNTRY
    SET WRITE_PROTECTED = 'Y'
    WHERE CTR_CODE = 'DE'

UPDATE schema.DNI_BIC
    SET WRITE_PROTECTED = 'Y'
    WHERE BIC_RECORD_KEY = 'DE000001';

UPDATE schema.DNI_CURRENCY_CTR
    SET WRITE_PROTECTED = 'Y'
    WHERE CUR_CODE = 'EUR' AND CTR_CODE = 'DE'