Design catalog

For high speed access to internal information about views and view columns, DQL processing uses a design catalog that contains design data extracted from view notes. Use updall command to add a design catalog to individual databases and to keep the design catalog up to date.

Once any database has been catalogued, DQL queries will operate without a design catalog. Only the <'View or folder name'>.<Columnname> syntax will fail. All other syntax will function but there will be no view access and all terms will be satisfied utilizing NSF scanning.

DQL processing is greatly enhanced by adding design catalogs to individual databases. To create a design catalog within a database, use the following command:
load updall <database path> -e

If <database path> is omitted, a design catalog will be added to all databases under the data directory. Doing this is not recommended as it is a rather large superset of what applications need to run DQL.

If you change the design of a view or add a view, run the following command to update the design catalog to make the changes visible to DQL:

load updall <database path> -d
Note: These two updall commands are always run manually.