Script

Description

changeProjectOfSaves.sql

Change the project to which save events and marker creation events occur. This script requires a user name, a time range, the project ID under which the event is currently associated, and the project ID to which the event is being located. This script is only valid for direct projects, and is used with the viewSaves.sql script.

copyPaperChart.sql

Create an identical version of an existing chart. The new chart includes metadata – such as edition number, version number, and chart status – from the original chart. All cartographic and hydrographic features along with attributes are also copied. The chart is given a new name while the script is run.

deleteProductUpdate.sql

Permanently remove an HPD product version (paper chart, AML, ENC, GML, etc.) from the database. The product version must be set to Rejected before it can be deleted.

renameVectorProduct.sql

Set new user-defined names for existing S-57, GML and Tiled Raster products.

restoreSourceFeature.sql

Restore any features that have not been confirmed as deleted. This includes features that have been split into other features or merged into another feature. Applying this script changes the history of the feature so that it appears as though the feature was never removed.

setproductsoundingrounding.sql

Update the sounding rounding setting of an S-57 product. The original sounding rounding value will not be saved. The values of the sounding rounding must be set to the values defined in SoundingRounding.xml.

setSchemaOwnerSubAgency.sql

Assign a subagency (other than the default) to the HPD schema owner. The available subagencies are derived from those created in the Sub-Agency Editor.

updateProductEdition.sql

Update the edition of a vector or paper chart product.

updateVectorATTFLE.sql

Update a vector product’s ATTF lexical level to 0 or 1. This script is valid for active New Editions or Updates, but it cannot be run on products that have a Rejected or Retired flag.

updateVectorNATFLE.sql

Update a vector product’s NATF lexical level to 0, 1 or 2. This script is valid for active New Editions or Updates, but it cannot be run on products that have been flagged as Rejected or Retired.

viewSaves.sql

Display saves made within a project. The script prompts for a time range, project ID and user name. It then lists all saves made by that user to the project within the time range. This script is used in conjunction with the changeProjectOfSaves script.

Note that the user name must be entered entirely in uppercase letters.