Oracle Application Software 10.1.3.4 User Manual
Metadata for the IMS/DB Data Source
A-6
Oracle Application Server Adapters for IMS/DB User's Guide
Table A–4
Metadata Properties
Property
Description
Alias
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.
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.
Autoincrement
The current field is updated automatically by the data source
during an INSERT statement and is not explicitly defined in the
INSERT
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.
order number field whose value is incremental each time a new
order is entered to the data source.
Comment
A short note or description about the column.
DB command
IMS/DB specific commands for the column The information
displayed is generated automatically when the metadata is
generated and should not be modified
displayed is generated automatically when the metadata is
generated and should not be modified
Empty value
The value for the field in an insert operation, when a value is not
specified.
specified.
Explicit Select
When true, the current field is not returned when you execute a
SELECT * FROM...
SELECT * FROM...
statement. To return this field, you must
explicitly ask for it in a query, for example, SELECT NATION_
ID, SYSKEY FROM 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.
retrieve a field defined with the Explicit Select value.
Hidden
The current field is hidden from users. The field is not displayed
when a DESCRIBE statement is executed on the table.
when a DESCRIBE statement is executed on the table.
Non Selectable
When true, the current field is never returned when you
execute an SQL statement. The field is displayed when a
DESCRIBE
execute an SQL statement. The field is displayed when a
DESCRIBE
statement is executed on the table.
Non Updateable
If true, the current field cannot be updated.
Nullable
This value allows the current field to contain NULL values.
Null value
The null value for the field during an insert operation, when a
value is not specified.
value is not specified.
Chapter of
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.
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
OnBit
The position of the bit in a BIT field and the starting bit in a
BITS
BITS
field.
Subfield of
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.
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.
is set by default to an offset of 1.
Subfield start
The offset within the parent field where a subfield starts.