(Contents)(Previous)(Next)

Object Lists

The object list contains an object occurrence (e.g., a table) on each line. The columns of the object list are the object attributes. Most objects are described in full in the object list. However, some of the database objects are made complex by the fact that they comprise a number of objects (a table comprises several columns); for this reason, their complete structure is displayed in design mode rather than in the object list.

Within an object list, you can scroll linewise or pagewise using the scroll arrows of the scroll bar on the right, or you can jump directly to the first or last row of the list.

Listing All Objects of One Type

From the object type menu, select the Object / List All Objects menu function or click on the toolbar button to display a list of all objects of the selected object type. This list contains all the objects that you are authorized to view. The search arguments used for this list are displayed as *.* in the bar above the displayed list.

Listing All Objects of One Type of Which You Are the Owner

From the object type menu, select the Object / List Own Objects menu function or click on the toolbar button to display a list of all objects of which you are the owner. The search arguments displayed in the bar above the list contain the owner names of the objects (<username>.*).

Selecting an Object List

Select the Object / Select Objects menu function or click on the toolbar button to display a dialog box in which you can enter search arguments for selecting the object list. The dialog box varies according to the object; for example, you can enter the owner and table name as a search pattern for a Table object, and you can restrict the list to the base tables or include view, synonym, result, or snapshot tables. If you enter * in all the text boxes, DOMAIN displays all objects for which you have access privileges.

All expressions known for the LIKE predicate of the SELECT statement (see the ADABAS Reference manual) can be used as a search pattern. For example, for the search pattern "???(ab)*" all names are searched that begin with three arbitrary characters that are followed by an uppercase A or B and any number of arbitrary characters.

In this example, all tables are displayed that belong to users whose names begin with "sqltravel2" and the current user is authorized to access. Note that the search arguments to be entered in the dialog box are case sensitive.

Customizing the Object Lists

As is typical when working with Windows, you can customize the tabular-format object lists. Until they are changed, any customizations you select apply to all object lists of one object type. To customize the object lists, you must already be familiar with Windows interfaces; for this reason, the description below uses specialized Windows terminology:

- Select the Windows Edit / Copy menu item in order to pass the rows of the tabular presentation as usual to other Windows tools.

- Select the Edit / Comment menu item to open the window in which the comment for the object is displayed. You can create and modify the comment if you are the owner of the object.

- Select the Format menu item to delete columns from and add columns to the tabular presentation (Show Columns), and to define fixed columns (Freeze Columns). Use Size to Fit to output columns at their minimum width. Use Gridlines to enable and disable grid lines.

- Under Records, use the Goto menu item to page through and the Refresh menu item or the toolbar button to refresh the display. This also updates the list to reflect changes to the object. Select Quick Sort to sort the table column by column using up to three columns as sort criteria. When doing so, only the visible rows are selected, not the total set of result rows.

To exit an object list, close the window or call the Object / Close function.

From the object list, you can access:

- Object editing or design mode, in which you can display or modify the object selected using the Object / Design menu item or clicking on the toolbar button. For application objects, there is no design mode.

- Object editing to define a new object of the selected object type using the Object / New menu item or by clicking on the toolbar button.

- The list of objects that use the selected object by selecting the Relships / Uses Relships menu item. All relationships are provided for selection in which the object occurs as using object.

- The list of objects used by the selected object by selecting the Relships / Used by Relships menu item. All relationships are provided for selection in which the object occurs as used object.

- The relationship display to select the desired relationship from all relationships involving the object by selecting the Relships / All Object Relships menu item.

- A list of statistical information about the chosen object by selecting the Object / Statistic menu item or by clicking on the button when you are in a Table, Index, or User list.


(Contents)(Previous)(Next)