Oracle Application Server 10.1.3.4, User Manual

Page: 123 / 170

Metadata for the IMS/DB Data Source
Advanced Tuning of the Metadata A-5
The buttons on the right side of the tab are used to manipulate the data in this section
of the tab. The following table describes how you can move around in this section.
Column Properties
You can change the property value by clicking in the
Value
column. Follow these steps
for displaying the column properties.
To display the column properties
■
Select a column from the Column Definition (top) section.
The properties for the column are displayed at the bottom of the tab.
The following table shows some of the properties available for selected columns.
Fixed offset This column lets you determine whether to calculate the offset.
There are two options:
■
Calc offset: If you clear this check box, the absolute offset for
each of the columns is calculated.
■
Fixed offset: When you select this check box, you will have a
fixed offset.
The offset of a field is usually calculated dynamically by the
server at runtime according the offset and size of the
proceeding column. Select the check box in this column to
override this calculation and specify a fixed offset at design
time. This can happen if there is a part of the buffer that you
want to skip.
By selecting the check box, or by editing the offset value you
pin the offset for that column. The indicated value is used at
runtime for the column instead of a calculated value. Note
that the offset of following columns that do not have a fixed
offset are calculated from this fixed position.
Primary Key Select this to indicate that this column is a primary key.
Table A–3 Definition Section Buttons
Button Description
Insert Inserts a column to the table. You can insert a new column. If the
table has arrays, you can add a new child column.
Up Moves your selection to the column directly above where the
currently selected column.
Down Moves your selection to the column directly below where the
currently selected column
Rename Lets you rename the selected column.
Delete Deletes the selected column.
Find Click this button to open a list of all columns in the database.
Select a column and click
OK to select it in the table.
Table A–2 (Cont.) Metadata Column Tab Definitions
Field name Description