CARIS HPD : Database Administration : Database Configuration : Database Configuration Settings : Updates from Source
 

Updates from Source

ENC and AML

When a feature in an AML or ENC product is updated from source, it retains the certification status of Verified.

The status flag can be reset to Under Construction using the PL/SQL procedure SET_UPDATE_ENC_FROM_SRC_CERT.

1. Open a Command Prompt.

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

3. Press <Enter>.

SQLPlus is activated.

4. Type this procedure:

exec p_hpdconfig.SET_UPDATE_ENC_FROM_SRC_CERT(’Under Construction’);

5. Press <Enter>.

6. Type commit;

7. Press <Enter>.

Paper chart

When a feature in a chart panel is updated from source, the feature retains the certification status of Verified.

The status flag can be reset to Under Construction using the PL/SQL procedure SET_UPDATE_PCE_FROM_SRC_CERT.

1. Open a Command Prompt.

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

3. Press <Enter>.

The SQL session is activated.

4. Type the procedure:

exec p_hpdconfig.SET_UPDATE_PCE_FROM_SRC_CERT(’Under Construction’);

5. Press <Enter>.

6. Type commit;

7. Press <Enter>.