Dataset Information (Read-Only Properties)
Databridge Servers > Client Managers > Settings > Customize > (select data set ) > Settings > Information
The read-only properties for a data set are organized in the following sections:
The editable properties also appear in the Properties page for the data set.
This section has two properties: Active and Mode, which corresponds to the
ds_mode columns in the DATASETS Client control table. Both properties can be edited from the Data Set Properties Page.
This section contains two items Item name Prefix and Extract Priority, they correspond to the values of the
extract_priority in the DATASESTS Client control table. Both of these can be edited from the Data Set Properties Page.
This section contains the values for relevant bits in the
misc_flags column of the DATASETS Client control table that are useful when customizing the data set. The Altered bit (
DSFLG_Altered) when set, indicates that the data was altered by the Databridge Support library. The Has Links bit (
DSFLG_Links) when set, indicates that the data set has links to other data sets. The RSN bit (
DSFLG_Static_AA) when set, indicates that the Databridge Engine is using RSNs in place of AA Values. The Valid AA bit (
DSFLG_Valid_AA) when set, indicates that the data set has valid AA Values. The Valid Parent AA bit (DSFLG_Uses_Parent_AA) when set, indicates that the data set, which is an embedded data set whose parent data set has valid AA Values. The embedded data set uses a column named
parent_aa as a foreign key that points to the parent data set record with the given AA value.
This section contains a series of options that represents individual bits in the
ds_options column of the DATASETS table. The History Tables parameter, which controls two mutually exclusive
ds_options is represented by a list box with 3 entries (
Save History and
Save History Only to prevent both bits from being set).
Refer to the DATASETS Client control table in the Databridge Client Administrator's Guide for more information about these bits. The various option bits are listed below with their corresponding names used in the Databridge Client Administrator's Guide and the configuration file parameter(s) which define their initial values when applicable. You can change the setting for these bits on a data set by dataset basis using customization. You should set the parameter in the configuration file using the Configure command to reflect the most commonly used settings, as this will reduce the amount of changes needed.
|Name in UI||Name in Client Administrator's Guide||mask||config parameter|
|Clear Duplicate Extract records||DSOPT_Clrdup_Recs||32,768||clr_dup_extr_recs|
|History Tables > Save History||DSOPT_Save_Updates||8||
|History Tables > Save History Only||DSOPT_HistoryOnly||8192||
|Ignore New Columns||DSOPT_Supp_New_Columns||256||
|Keep NULL Alapha keys||DSOPT_Keep_Null_Alpha_Keys||128|
|Optimize SQL Updates||DSOPT_Use_bi_ai||1||
|Split variable Format Dataset||DSOPT_Use_AA_Only||65,536||
|Use AA Values (or RSNs) as Keys||DSOPT_Use_AA_Only||16,384|
|No Stored Procs in Updates||DSOPT_No_StoredProcs||4||
|Use Internal Clone||DSOPT_Internal_Clone||4,194,304||
|Use BCP utility||DSUPT_Use_BCP||16,777,216||
See the DATASETS Client Control table in the Databridge Client Administrator's Guide for more information. You can change the setting for these bits on a data set on a date set basis using customization. You should set the parameter in the configuration file to reflect the most commonly used setting, as this will reduce the amount of changes needed
Virtual Data Set
This section allows you to link virtual data sets and real data sets from which they are derived using the
real_ds-rectype columns in the DATASETS client control table. The two controls are list-boxes that contain all the qualifying data sets that are available.
This section lists the various user columns that will be added to the data set. These bits default to the value defined by the
external_columns parameter in the Client configuration file. This set of options allows you to further customize the user columns to be used for the tables derived from this data set.