CARIS HPD : HPD® Server API : Database Setup : P_HPDCONFIG
 

P_HPDCONFIG

 
SET_UPDATE_PCE_FROM_SRC_CERT
SET_UPDATE_ENC_FROM_SRC_CERT
ENFORCE_PRODUCT_LOCKING
LOAD_ATTACHED_FILES
SET_SOURCE_GEOGRAPHIC_CRS
SET_SOURCE_GEOGRAPHIC_CRS_WKT

Name

Type

Description

SET_UPDATE_PCE_FROM_SRC_CERT

Procedure

Defines how Verified source objects are treated during "compare product to source" for paper chart features.

SET_UPDATE_ENC_FROM_SRC_CERT

Procedure

Defines how Verified source objects are treated during "compare product to source" for vector product features (e.g.,S-57, S-100).

ENFORCE_PRODUCT_LOCKING

Procedure

Sets a product to locked (only one user at a time can edit the product) or unlocked (more than one user can edit the product).

LOAD_ATTACHED_FILES

Procedure

Loads external files that are associated with attributes (e.g., PICREP, TXTDSC) to the database.

SET_SOURCE_GEOGRAPHIC_CRS

Procedure

Sets the coordinate reference system information for all HPD source data.

SET_SOURCE_GEOGRAPHIC_CRS_WKT

Procedure

Sets the coordinate reference system information for all HPD source data using a Well-Known Text (WKT) representation of a coordinate reference system.

The schema owner can query and check the status of the various settings using the following command:

select * from hpdconfig;

A report containing the following data is displayed:

Name

Type

Possible Values

SOUNDINGROUND

VARCHAR2

Name of a sounding rounding rule in the sounding rounding file (uslXSndRndCfg). Used when creating Product definitions with P_ENCAPI and P_GPEAPI.

Default: Default Metres

UPDATE_ENC_FROM_SOURCE_CERT

INTEGER

1 = Verified

6 = Under Construction

UPDATE_PCE_FROM_SOURCE_CERT

INTEGER

1 = Verified

6 = Under Construction

EnforceProductLocking

INTEGER

0 = Disable product locking

1 = Enable product locking

LoadAttachedFiles

VARCHAR2

N = Files not stored in database

Y = Files stored in database