CARIS HPD : Database Administration : Creating and Setting Up a New HPD Schema : PCE Geographic Attributes - Read-Only or Editable (Oracle) : AML Catalogues and Usages
 

AML Catalogues and Usages

To add Additional Military Layers (AML) to a schema, two scripts must be run:

• LoadCatalog.sql appends the AML catalogue to the S-57 catalogue.

• AMLUsages.sql creates AML scale bands.

These scripts are located in C:\ProgramData\CARIS\HPD\<version>\Server\AML<version>.

Note that there are two AML versions: 2.1 and 1.0. HPD can create either AML 2.1 or AML 1.0 products, but not both.

When the AMLusages.sql script is run, it overwrites any prior usages. To add usages manually with the Usage Manager, see Usages.

AML scripts must be applied before user-defined dictionary and catalogue changes are added to the schema. For more information on catalogues, see HPD Catalogues.

The following steps show how to run these scripts in sequence.

1. Open Command Prompt.

2. Navigate to the AML<version> folder.

3. Start an SQL session as the schema owner:
sqlplus <schema_owner>/<password>@<database>

4. Press <Enter>.

SQLPlus is activated.

5. At the SQL prompt, enter @LoadCatalog.sql

6. Press <Enter>.

When the script is compete, you are disconnected from SQLPlus.

7. Start another SQL session as the schema owner.

8. Press <Enter>.

SQLPlus is activated.

9. At the SQL prompt, enter @AMLUsages.sql

10. Press <Enter>.

The AML usages are created, and the AML schema is ready for use.