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.