EM: Databases/SQL: Databases
> Types
Description
The
Databases Tables displays the list of defined database types and their properties, allowing users to view, configure, and manage type-specific settings such as formatting, storage behavior, and default values within the selected database.
Note: Selecting a database from
Databases name list, opens its configuration interface, and enabling access to Types .
Location
EM Navigator →
Databases/SQL →
Databases → Types
Toolbar
| Button | Function |
|---|---|
|
Creates a news type. |
|
Edits selected type(s). |
|
Removes/deletes selected type. |
|
Refreshes the information. |
Types: Column Settings
Displays defined database types with names and descriptions, enabling selection and management of type configurations.
Column Settings
| Settings | Description |
|---|---|
|
Name of the type definition. The data dictionary stores this name for column type when a column uses a type definition. |
|
|
The defined description of each database type, providing additional context or usage details. |
Creating New Type
Opens a form after clicking the
icon to create a new database type, allowing configuration of General properties such as name, base type, formatting, and default values, while the Legacy section contains deprecated fields not used by the SQL engine.
General Settings
Provides configuration fields for defining a database type, including name, processing behavior, formatting options, base type, and default values.
Note: Only three of the fields on this dialog are used by the SQL engine. The remaining fields are legacy items no longer used by BBj, but left in place for those developers who rely on information stored in these fields. This documentation only addresses those fields recognized by BBj.
General Settings
| Settings | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Name of the type definition. The data dictionary stores this name for column type when a column uses a type definition. |
|||||||||||||||||||||||||||||||||||||||||||||||||||
|
Description for the content of the type. |
|||||||||||||||||||||||||||||||||||||||||||||||||||
|
Value processor to use for encoding/ decoding the data in a field value stored in a record.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||
|
Date format to be used when evaluating the type definition.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||
|
The base BBx/BBj data type for this definition. These types correspond to BBx/BBj template data types such as N, C, I, B, etc.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||
|
The length of the field definition for the raw data in the record. This may be different than the precision |
|||||||||||||||||||||||||||||||||||||||||||||||||||
|
SQL precision for this type that will be returned to JDBC and ODBC applications. This is the total number of digits allowed in a value including those digit before and after the decimal point. |
|||||||||||||||||||||||||||||||||||||||||||||||||||
|
The total number of digits after the decimal point. A number 123.45 would have a precision of 5 and a scale of 2. |
|||||||||||||||||||||||||||||||||||||||||||||||||||
|
Default value for this type. If none is specified, null will be used when applicable. |
Legacy(not honored by SQL engine)
Note: The fields in this section are ignored by the SQL engine and only left in place for legacy purposes. Some applications have values stored in these fields and interpret those values on an application-specific basis.