Data Item Information (Read-Only Properties)

Getting there

Databridge Servers > Client Managers > Settings > Customize > (select a data set) > Relational > Settings > (select a data item) > Information

The read-only properties for a data item are organized into Basic and Options sections.

Basic Properties

This section has one updatable property, Table Name.

Data Type

This entry is redundant as the data type is already included in the item name.

Derived from

This entry displays the name and data type of the DMS item from which the item was derived.

Active

This entry shows the value of the active column for the corresponding entry in the DATAITEMS Client control table.

Item Key

This entry corresponds to the item_key column in the DATAITEMS Client control table for the item.

Options

The entries below can be useful to find out why the column is marked as being customized.

Column Renamed

Indicates that the column was renamed.

Length Changed

Indicates that sql_length was changed in the corresponding DATAITEMS entry.

Scale Changed

Indicates that sql_scale was changed in the corresponding DATAITEMS entry.

Replicating as Char

Indicates that the da_options bit DAOPT_Store_as_Char is set in the corresponding DATAITEMS entry. This is the result of a customization done in the DMSII view that enables the Replicate as Alpha option.

Translating Binary Data

Indicates that the da_options bit DAOPT_Xlate_Binary is set in the corresponding DATAITEMS entry. This is the result of a customization done in the DMSII view that enables the Replicate as Binary option and sets Translate Binary Data to True.

Replicating as Number

Indicates that the da_options bit DAOPT_Store_as_Number is set in the corresponding DATAITEMS entry. This is the result of a customization done in the DMSII view that enables the Replicate as Number option.

Type Changed

Indicates that sql_type was changed in the corresponding DATAITEMS entry.

Using Custom Date Format

Indicates that the da_options bit DAOPT_VarFormat_Date is set in the corresponding DATAITEMS entry. This bit tells the Client how to interpret the dms_subtype column. This is the result of a customization done in the DMSII view that enables the Replicate as Custom Date option.