Defining data with an access definition

You can use an access definition to define data for Optim™ processes such as archive and extract.

To define data with an access definition:

  1. In the main window, select New from the File menu.
  2. Select Access Definition from the Definitions submenu. The Access Definition Editor opens and the Tables tab is displayed.
  3. Specify the name of the Default Qualifier for the tables.
  4. Specify the name of the Start Table.
  5. Specify other tables/views and other values in the list of tables. Use the Table Specifications shortcut menu option to open the Table Specifications window and specify selection criteria for the data extracted from the tables.
  6. Optional – Use the tabs in the Access Definition Editor to specify additional criteria and options for selecting data. See Using the Editor for complete details.
  7. In the Access Definition Editor, select Save from the File menu to open the Save the Access Definition dialog.
  8. In the Pattern box, type a unique name for the new Access Definition and then click Save.
Note: In addition, you can open the Access Definition Editor from the Tools menu in the Extract Request, Archive Request, or Compare Request Editor. For details, see the appropriate chapter in the corresponding user manual.