- Database Settings

Database Settings

• • System Alias - The name of the alias being used for the current connection.

  • Column Size - The amount of information the described field can contain. This setting specifies the maximum number of characters or digits that can be stored in this field's database column.

  • Library Name - The name of the library that the described field is located in. If the Field Descriptor is shared among tables in multiple libraries, this field will contain an asterisk.

  • Scale - For a numeric type field, this is the number of digits to the right of the decimal point.

  • Table Name - The name of the table that the described field is located in.

  • Nullable - Whether or not the field can contain null values.

  • SQL Type - This is the corresponding SQL data type for the field.

  • SQL Type Name - This is the corresponding SQL data type for the field.

Key Position - Defaults to 0 for non-key fields. This field represents the position of this field in the table's key. For instance, if this table (Table Name) has only one key, and this FD is the key field, then the key position should be 1. If this table's key is made up of two columns, you need to set the FDs appropriately. If a Field Descriptor is not a key, this value should be 0. Keys are used to identify a unique record (row) within the table. Only one row is allowed to exist with each key (or set of key values).