Click or drag to resize

SAVE LOOKUP Statement

Verizon Connect Logo
Print this page
Learn more about Verizon Connect GeoBase.
Get information about the latest release
SAVE LOOKUP Statement

The SAVE LOOKUP statement saves a lookup that has previously been created using the CREATE LOOKUP statement.

Tip Tip

For information about the lookup table, see the lookup function

Syntax

Alchemy
Copy
SAVE LOOKUP ident AS filename;

Nomenclature

identThe identifier for this lookup table
filenameThe path to the file that the lookup should be saved to

Example

This simple example saves a lookup on post (ZIP) codes by city, which has been previously created.

Alchemy
Copy
SAVE LOOKUP cityFromPostcode AS "Lookups\CityFromPostcode.db";

You can then use the statement LOAD LOOKUP to retrieve the saved lookup at a later time.