Creating and using a workbook

To create a workbook, you use the Workbook wizard.

To create a workbook:

  1. Click File --> New Workbook and click OK.
  2. Click Next on the Welcome page.
  3. Select a data source and click Next.
  4. Select database objects to customize your workbook.
  5. Type the owner name in the Object Owner field to restrict the objects to those belonging to a single owner.
  6. Select table relationships.

    Click Next.

  7. Select types of functions and click Next.
  8. Select tables, views, and synonyms and click Next.
  9. Select procedures and click Finish.

To delete a workbook, delete its file (workbook.vwb) from your file system or select it in the Open dialog box and press Delete.

In a workbook, you can use the Workbooks page of the World Manager to perform the following tasks:

The following figure shows the World Manager displaying a workbook.

The Data folder contains tables, views, and synonyms in the workbook. You can right-click the Data folder and click Remove this node but show contents to remove the folder, but not its contents, from the workbook.

The Table folder contains columns. You can right-click a table or column and click Delete to remove it from the workbook or Properties to view properties and, for tables, to edit table relationships.

The Types folder contains data types and the Functions folder contains the functions in the workbook. You can right-click the Types or Functions folders and click Don't Display This Item to hide it or Delete to remove it from the workbook.

The QMF Queries folder (not shown) contains QMF queries.

[ Previous Page | Next Page | Contents | Index ]