Using SQL to maintain and query the reference data

After you use RDU to import SWIFT BICDirectory/BIC Directory 2018 or BankDirectoryPlus data files into the reference data tables, you can use SQL statements to query the corresponding reference data views or to manipulate the data.

Use the following views for write actions:
- DNI_BIC
- DNI_COUNTRY
- DNI_CURRENCY_CTR
Use the following views for read actions only:
- DNI_CURRENCY
- DNI_CUR_CTR_REL

Currency view dependencies are described in Currency view dependencies.

Note: Instead of using SQL statements, the AO Facility Reference Data component can be used to display and modify reference data. For more information, see Managing reference data.