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.
Shortcut menu commands allow you 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
desired position.
- Move
- You can move a grid column or row. To move a grid:
- column, select the heading and drag the column.
- 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
the grid contains more information than can be viewed on your monitor,
you can use the horizontal and vertical scroll bars to adjust the
display left and right or to view entries on a list 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 used to select rows to be excluded.
- Include
- Open the Include dialog where
you can enter a value or string 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 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
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
(e.g., 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 (i.e.,
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:
- 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.