Getting started

DQL processing uses extracted, optimized design data to make intelligent choices about query plans and to work with some of its syntactic elements like view names. To do that, you first need to create and keep up to date that data in a catalog kept in your data directory, named

About this task

To create you run updall with the name of your database with the -e option:
load updall myappdb.nsf -e

The first time the command is issued, is created with a single database cataloged within it. But you must add each database you are going to query using DQL to the catalog in the same manner. It is not recommended that you add all databases to the design catalog; that is a large superset of the extracted data that you will need.

For more on this subject, see the topic Design Catalog.