Was this helpful?
Catalog Frames for Query Target Selection
Each type of query target—QBFName, JoinDef, and table—has its own Catalog frame. Each Catalog frame offers various operations, such as create, destroy, edit, or examine, that are specific to that type of query target. The Tables Catalog frame operations are discussed in detail in the chapter "Using the Tables Utility." Operations on the JoinDefs and QBFNames Catalog frames are discussed in the chapters "Using JoinDefs in QBF" and "Using VIFRED."
All catalog frames offer the following standard operations for use with QBF:
Go
Runs a query on the target you choose
Help, Quit
Standard operations
QBFNames Catalog Frame
The QBFNames Catalog frame, shown here, contains a list of the QBFNames that you can access. A QBFName represents a data display form designed or customized with the VIFRED and then linked to a JoinDef or table. For a discussion of QBFNames, see the chapter "Using VIFRED."
Choosing a QBFName query target from the QBFNames Catalog frame informs QBF to use the customized data display form and the associated JoinDef or table in the query operation.
JoinDefs Catalog Frame
The JoinDefs Catalog frame, shown here, contains a list of the JoinDefs that you can access.
Tables Catalog Frame
The Tables Catalog frame, shown in the following figure, lists the names and owners of all tables and views to which you have access in the current database.
Choose any table or view in the Tables Catalog frame as a query target for query execution. However, when executing a query on a view, you can only perform a Retrieve operation. You cannot perform the Update or Append operations on a view. For more information on views, see the chapter "Using the Tables Utility."
Last modified date: 01/30/2023