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

PCE Geographic Attributes - Read-Only or Editable (Oracle)

 
Product Schemas
DNC Catalogues and Usages
AML Catalogues and Usages
IENC Catalogues and Usages
LOS Catalogue
HCRF Features and Attributes

The PCEGeographicAttsNotReadOnly.sql script removes the read-only flag on attributes for geographic features in a paper chart profile. This means you can create new geographic features directly in the panel and also edit the attributes of geographic features.

This script can be run on new schemas or existing schemas.

When the script is run, the change is applied to all charts in the schema. All new charts will also have attributes set to be editable. Attributes can be reset to read-only by modifying the paper chart profile through Catalogue Editor. The only exceptions are attributes associated with collection objects and cartographic objects.

Before running this script, always back up your schema. This script permanently modifies all geographic feature attributes in the catalogue.

1. In Command Prompt, navigate to C:\ProgramData\CARIS\HPD\<version>\Server\admintools.

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

3. Press <Enter>.

The SQL session is started.

4. To run the script, enter @PCEGeographicAttsNotReadOnly.sql

5. Press <Enter>.

The following is displayed in Command Prompt.

FILENAME

--------------------------------------------------------------------------

PCEGeographicAttsNotReadOnly_<system_date_time>.log

==========================================================================

PCE Geographic Attributes become not Readonly

==========================================================================

This changes all profiles associated with Paper Chart Editor (PCE) so that

all attributes of geographic features are set to be not readonly.

==========================================================================

 

==========================================================================

WARNING!

==========================================================================

 

THIS SCRIPT PERMANENTLY MODIFIES THE CATALOG.

 

CARIS strongly recommends you backup your schema before continuing

 

==========================================================================

 

Do you wish to continue? (Yes/No):

 

6. Type Yes to continue or No to cancel, and press <Enter>.