Click or drag to resize

COMMIT Statement

Verizon Connect Logo
Print this page
Learn more about Verizon Connect GeoBase.
Get information about the latest release
COMMIT STATEMENT

The COMMIT statement updates any destination tables modified by previously executed IMPORT POLYGONS, IMPORT STREETS and IMPORT CONSTRAINTS statements.

A COMMIT statement frees resources, so by making regular COMMIT statements performance can be increased.

Once an IMPORT STREETS statement has been committed to its destination table the street links associated with that IMPORT STREETS statement are no longer available to the Alchemy tool.

Caution note Caution

The IMPORT CONSTRAINTS statement needs access to relevant street data. Therefore you'll need to ensure that relevant street link data (from one or more IMPORT STREETS statements) is not committed until all the relevant constraints have been imported.

Syntax

Alchemy
IMPORT STREETS [...];
IMPORT CONSTRAINTS [...];
COMMIT;