A Advanced Tuning of the Metadata

The name of the column

The data type of the column. Selecting this field displays a list of possible data types.

The size of the column

The information entered in this field depends on the data type:

For decimal data types, this is the number of digits to the right of the decimal place. This number must not be greater than the number of digits. The default value is 0.

For scaled data types, this is the total number of digits. The number must be negative.

The maximum number of occurrences of a group of columns that are part of an array.

The (+) to the left of a column indicates a group field. This type of field has a Dimension value. Click (+) to display the group members.

An absolute offset for the field in a record.

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 have a fixed offset.

  The offset of a field is usually calculated dynamically by the server at run-time 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 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 run time 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.

Select this to indicate that this column is a primary key.

Inserts a column to the table. You can insert a new column. If the table has arrays, you can add a new child column.

Moves your selection to the column directly above where the currently selected column.

Moves your selection to the column directly below where the currently selected column

Lets you rename the selected column.

Deletes the selected column.

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.

A name used to replace the default virtual table name for an array. Virtual table names are created by adding the array name to the record name. When an array includes another array the name of the nested array is the name of the record and the parent array and the nested array. When the default generated virtual table name is too long, use an Alias to replace the long name.

The current field is updated automatically by the data source during an INSERT statement and is not explicitly defined in the INSERT statement. The INSERT statement should include an explicit list of values. This attribute is used for fields such as an order number field whose value is incremental each time a new order is entered to the data source.

A short note or description about the column.

IMS/DB specific commands for the column The information displayed is generated automatically when the metadata is generated and should not be modified

The value for the field in an insert operation, when a value is not specified.

When true, the current field is not returned when you execute a SELECT * FROM... statement. To return this field, you must explicitly ask for it in a query, for example, SELECT NATION_ID, SYSKEY FROM NATION where SYSKEY is a field defined with Explicit Select.

You cannot use an asterisk (*) in a query where you want to retrieve a field defined with the Explicit Select value.

The current field is hidden from users. The field is not displayed when a DESCRIBE statement is executed on the table.

When true, the current field is never returned when you execute an SQL statement. The field is displayed when a DESCRIBE statement is executed on the table.

If true, the current field cannot be updated.

This value allows the current field to contain NULL values.

The null value for the field during an insert operation, when a value is not specified.

This property shows that the set member field is a chapter of an owner field. A value for this property must be used when accessing a set member as a chapter in an ADO application.

This property is used for DBMS metadata

The position of the bit in a BIT field and the starting bit in a BITS field.

The value is generated automatically when you generate metadata from Adabas data that includes a superdescriptor based on a subfield. A field is created to base this index on, set to the offset specified as the value of the Subfield start field.

If no value is entered in the Subfield start field, the subfield is set by default to an offset of 1.

The offset within the parent field where a subfield starts.

The names of existing indexes for the current table.

The ordering of the rows retrieved by the index.

IMS/DB-specific commands for the index. The information displayed is generated automatically when the metadata is generated and should not be modified.

Inserts an index to the table.

Lets you rename the selected index.

Deletes the selected index.

An estimation of the amount of statistical information returned.

An estimation of the amount of statistical information returned. The estimate includes an estimation of the number of rows in the table. Specify the number in the text box. This number is used to shorten the time to produce the statistics if the value specified here is the correct value, or close to the correct value.

The exact statistical information returned. Note that this can be a lengthy task and can lead to disk space problems with large tables.

Only information about the table and indexes is collected. Information for partial indexes and columns is not collected.

Information about the table, indexes, partial indexes and columns is collected.

Enables you to select the columns and indexes for which you want to collect statistics. In the enabled list of columns or indexes, left click those columns you want included (you can use shift-click and control-click to select multiple columns or indexes).