To create a Digital Nautical Chart (DNC®) schema, two scripts must be run.
• @LoadCatalog.sql replaces the S-57 catalogue with a DNC catalogue.
• @DNCUsages.sql replaces default HPD usages with DNC usage bands.
These scripts are located in C:\ProgramData\CARIS\HPD\<version>\Server\DNC.
The scripts must be run in sequence, with the Loadcatalog.sql script run first.
To run the scripts:
1. Open Command Prompt.
2. Go to C:\ProgramData\CARIS\HPD\<version>\Server\DNC.
3. Start an SQL session as schema owner:sqlplus <schema_owner>/<password>@<database>
4. Press <Enter>.
The SQL session is activated.
5. At the SQL session prompt, enter @LoadCatalog.sql
6. Press <Enter>.
When the script is complete, you are disconnected from SQLPlus.
7. Start another SQL session as the schema owner.
8. Press <Enter>.
SQLPlus is activated.
9. At the SQL session prompt, enter @DNCUsages.sql
10. Press <Enter>.
The DNC usages are created.