At times, you cannot display all grid columns and rows
on your monitor. To help navigate a large grid, you can scroll, resize,
or move grid rows and columns manually, or use key combinations to
move around a grid.
You can use shortcut menu commands to find,
replace, sort, hide, or lock grid columns and rows. Right-click a
grid heading or grid column to display a shortcut menu.
Grid handling features are similar throughout Optim; any
variations for specific editors and dialogs are discussed where applicable.
Adjust a grid manually
You
can easily resize, move, and scroll grid columns and rows to view
all the data in an editor or dialog. You can also delete a numbered
grid row.
- Resize
- To change the width of a grid column, position the
pointer at the right boundary of the column to click and drag to the
wanted position.
- Move
- You can move a grid column or row.
- To move a grid column, select the
heading and drag the column.
- To move a grid row, select a numbered
row and drag it to a new position. The rows renumber automatically.
- Scroll
- To view complete information in a grid cell, you
can resize the grid column to display the entire value or use the
horizontal scroll bar below the heading.
- Delete
- To delete a grid row, click a row number and press Delete.
Scroll bars
When
a grid contains more information than can be viewed on your monitor,
use the horizontal and vertical scroll bars to adjust the display
to view the additional information. You can scroll left or right and
from top to bottom.
Click
the scroll box to indicate the pointer position on the grid. The vertical
scroll box displays the row number and the total number of rows. The
horizontal scroll box displays the grid column number and the total
number of grid columns.
Key combinations
In
addition to using scroll bars, you can use the following key combinations
to move through grid columns and rows.
- Tab
- Move to the next read/write cell to the right.
- Shift+Tab
- Move one read/write cell to the left.
- Arrow Key
- Move one read/write cell in the direction of the
arrow key.
- Ctrl+Left Arrow
- Move to the beginning of a grid row.
- Ctrl+Right Arrow
- Move to the end of a grid row.
- Ctrl+Up Arrow
- Move to the top of a grid column.
- Ctrl+Down Arrow
- Move to the bottom of a grid column.
- Ctrl+Home
- Move to the first read/write cell in a grid.
- Ctrl+End
- Move to the last read/write cell in a grid.
- Page Up
- Scroll up through a grid.
- Page Down
- Scroll down through a grid.
Grid heading shortcut menu
Right-click a grid column heading
to display a shortcut menu. Select from the following commands to
adjust the grid display:
- Find
- Open the Find dialog where
you can specify search criteria to locate a particular value in a
grid column. For details on using Find and Replace commands,
see Using Find and Replace.
- Replace
- Open the Replace dialog where
you can enter a value or string to be replaced with a different value
or string (applies only to grid columns that can be updated).
- Exclude
- Open the Exclude dialog where
you can enter a value or string that is used to select rows to be
excluded.
- Include
- Open the Include dialog where
you can enter a value or string that is used to select rows to be
included.
- Sort
- Open the Sort menu where
you can rearrange the grid rows according to a value or string in
a grid column.
- Hide
- Hide a grid column. To redisplay the grid column,
select Unhide All or Reset Grid
Attributes from the shortcut menu.
- Unhide All
- Display hidden grid columns.
- Lock
- Move a grid column to the left and lock in place.
When you lock more than one column, the locked columns are positioned
in the order locked. The menu command is Unlock for
previously locked columns. To unlock a column, select Unlock.
Note: To
unlock all locked grid columns, select Reset Grid Attributes from
the shortcut menu.
- Reset Grid Attributes
- Return the grid components to the original settings,
display hidden grid columns, and unlock locked grid columns. Sorted
data remains unchanged.
- Print
- Open the Print dialog to print
the rows in the grid.
- Save
- Open the Save dialog to save
all or selected rows.
- Grid Patterns
- Display
the Grid Patterns dialog. Refer to this dialog
for a brief description of any cross-hatching patterns that are used
in the dialog from which you right-clicked.
- What's This
- Display the What's This? pointer.
Click a control in an editor or dialog with this pointer to obtain
context-sensitive help.
Prefix/Suffix dialog
The Prefix/Suffix dialog is
accessible from the grid header shortcut menu in the following dialogs:
- Access Definition Editor table grid
(Table grid column).
- Table Map Editor table grid (Destination
Table grid column).
- Archive Request Editor Extended
Object List grid (Object name grid column).
- Extract Request Editor Extended
Object List grid (Object name grid column).
- Create Utility grid (Object name
grid column). (You can add a prefix or suffix to the Creator-ID or
object-name parts of the Index, Primary Key, Relationship, Alias,
or Synonym database objects. All other database objects in the Create dialog
(for example, table, default, function, package, procedure, rule,
sequence, user-defined type, view) are optionally prefixed or suffixed
in the Table Map Editor.)
Right-click a grid column header and select
Prefix/Suffix to display the Prefix/Suffix dialog.
Use the Prefix/Suffix dialog to
add a prefix or suffix to any part of a database object name (such
as a table, default, function, package, procedure, rule, sequence,
user-defined type, or view) in the grid column beneath the header.
The following guidelines apply:
- In the Table Map Editor, the Prefix/Suffix dialog
applies to the Destination name column on all tabs (Tables, Defaults,
Functions, Packages, Procedures, Rules, Sequences, User Defined Types,
and Views).
- The Prefix/Suffix dialog
does not apply to the Column Map column on the Tables tab.
- The Prefix/Suffix dialog
is not available for a Compare Table Map.
- In the Extract Request Editor, the Prefix/Suffix dialog
applies to the Object Name column on the Object List tab.
The Prefix/Suffix dialog
includes the following items:
- Column
- Displays the name of the column header you right‑clicked.
- Operation
- Select whether to add a prefix or suffix to, or
replace, each item in the column, then enter the value to use.
- Apply to
- Select the part of the three part object name, as
applicable, to apply the prefix or suffix, or to replace.
Grid column shortcut menu
Right-click
a grid column to select from shortcut menu commands to edit the entry
in a grid cell. The typical field editing function commands are available
and correspond to the specific grid column.