DATAITEMS Control Table Changes
Besides the addition of the column da_user_bmask, several da_options bits are used to indicate that a specific field in the record was changed by the Client Configurator or a user script. These new da_options bits are described in the following table.
Note: Any time you explicitly change the value of a bit in da_options, you must set the corresponding bit in da_user_bmask. If you set a bit that had a default value of 1 to 0, you must set the corresponding bit in da_user_bmask to 1 to indicate that the value of this bit should be preserved by the redefine command.
DAOPT_Column_Renamed (2) |
This bit indicates that the column was renamed by changing the item_name column of the item. The redefine command uses this bit to determine if the item_name value should be preserved. |
DAOPT_Type_Changed (4) |
This bit indicates that the column’s data type was changed by changing the value in the sql_type column. The redefine command uses this bit to determine if the sql_type value should be preserved. |
DAOPT_Length_Changed (8) |
This bit indicates that the column’s data type length specification was changed by changing the value in the sql_length column. The redefine command uses this bit to determine if the sql_length value should be preserved. |
DAOPT_Scale_Changed (16) |
This bit indicates that the column’s data type scale was changed by changing the value in the sql_scale column. The redefine command uses this bit to determine if the sql_scale value should be preserved. |
DAOPT_User_Column (32) |
This bit indicates that the column was added by the user. The redefine command uses this bit to determine if the column should be preserved. |
DAOPT_Item_Renumbered (128) |
This bit indicates that the column was renumbered by the user. The redefine command uses this bit to determine if the item_number should be preserved. Caution: This will not always work because item numbers may change as a result of a DMSII reorganization. If you do this, you'll need to use the Client Configurator to get the column into the proper place. |
 |