| DB | Areas | X-idx | Tables | Sequences | <- _Db-Detail | _DbParams -> | HtmlDict 11 |
This tables provides an extension to the _db database table for additional database options (user defined fields). It is joined to the _db table via the _db-recid field as the RECID of the database never changes, whereas the database GUID does, which would result in lost database options. This is really a generic table to make the _db metadata extensible. The use of option types upto 32,000 are reserved for Progress internal use. An example entry in this table would be for a database option that controls whether to record authenticated client sessions or not in the _client-session table.
| Area | Schema Area |
|---|---|
| Dumpname | ? |
| Label | ? |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 4 | _Db-option-code | X | Database option code | character | X(35) | D: This is a code within the option type to identify a specific option, e.g. PVM.Session to decide whether to record authentication sessions y/n? | ||
| 5 | _Db-option-description | X | Database option description | character | X(500) | V: e sz 70 BY 8 sv MAX-CHARS 500 D: This is a free text description of the database option. |
||
| 3 | _Db-option-type | X | Database option type | integer | ->>>>>9 | 0 | D: This is the type of option to group related options together. Progress owns the first 32,000 option types. Example options types could be for security, auditing, context, etc. | |
| 6 | _Db-option-value | X | Database option value | character | X(70) | D: This is the value of the database option, e.g. for the option to record authenticated sessions it would contain yes or no. This is a character field. | ||
| 2 | _Db-recid | X | Database recid | recid | ->>>>>>>9 | 0 | D: This is the RECID of the _db table to identify the database these options are for. The RECID is used rather than the database GUID because the RECID never changes for a database, and this information is specific to a single database and has no meaning outside of a database. |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| _Option-code | P U | _Db-recid (+) | recid |
| _Db-option-type (+) | integer | ||
| _Db-option-code (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| generated 3-3-2025 10:54 |