Data Set Properties Dialog Box

Getting there

From the Databridge Enterprise window, right-click a data set and select Properties.

The properties in this dialog box are for information only and can't be edited.

Structure #	The unique number of the data set assigned by DMSII.
Record size	The size of the record, measured in words and bytes. (DMSII may allow larger record sizes than the relational database.)
Type	Indicates the physical organization of the data set. Certain data set types, such as STANDARD, do not move records and the AAs remain fixed until a reorganization. Other data set types, such as ORDERED, move records whenever needed and therefore do not have fixed AAs. For more information, see the documentation for DASDL Data and Structure Definition Language (DASDL) is the language that defines DMSII databases. The DASDL must be compiled to create a DESCRIPTION file. .
Format Level	Indicates the DASDL Data and Structure Definition Language (DASDL) is the language that defines DMSII databases. The DASDL must be compiled to create a DESCRIPTION file. update level when a change was last made to the layout of this data set.
Row filter	Click to open the Row Filter dialog box. This button appears only when viewing data set properties of DBEnterprise local (filtered) sources.
ALTERed	When selected, indicates that the definition of the data set has been altered from its original layout using the ALTER declaration in DBGenFormat A host utility that creates translation, filter, and format routines. The GenFormat utility interprets the GenFormat parameter file to generate ALGOL source code patches, which are included in the tailored Support Library. .
Reformatted	When selected, indicates that the data set layout has changed and requires either ALGOL code on the MCP server or C++ in Enterprise Server to reformat it.
Valid AA	When selected, indicates that the data record has an absolute address and may be suitable candidate for a key or primary key if a static AA is not available. The DMSII data set type (see Type) determines whether the AA is a valid key or not. Standard data sets, for example, have valid AAs.
Static AA	When selected, indicates that the data set includes a unique data item that won't change in the event of a reorganization and is therefore suitable for a key or primary key.
Links	When selected, indicates that the data set has one or more data items that refer to another record in this or another data set. A link can be sent to the client as a data item in an AA format and the table containing the link item can be joined with the table containing the target record. If checked, you may need to reclone this data set if the target data set is reorganized.
Extract only	When selected, indicates that the data set is embedded within a parent data set that does not have a valid AA (for example, Ordered or Compact). Records in this kind of embedded data set cannot be tracked. Also, if the DASDL option INDEPENDENTTRANS is reset, embedded data sets in the entire database cannot be tracked or fixed up. These embedded data sets can be extracted (the first phase of a clone), if the run-time option DBV_OP_EMB_EXTR is set.