Enterprise Manager - Database: Types

To view this topic for the preceding Enterprise Manager, see EM Java App: Database - Type Definitions Tab.

BBj databases use type definitions as a way to encapsulate a set of column related attributes in a single, named item.

For example, the ChileCompany database contains a type definition called NUM_DATE. The following image shows the definition for this type definition:

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:


Type Name

Name of the type definition. The data dictionary stores this name for column type when a column uses a type definition.

Base Type

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.

Length

The length used for columns using this type definition.

Dictionary Length

The length of the field definition for the raw data in the record.  This may be different than the precision.

Precision

The total number of digits allowed including those before and after the decimal point.  A number 123.45 would have a precision of 5.

Scale

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

The default value if none is specified.


See Also

Settings

JDBC How-To

SQL

Tables

Views

Procedures

Security

Query Analysis

Metadata Definition