Database - Type Definitions Tab


In BBj 13.0 and higher, the Enterprise Manager Java app has been superseded by a new browser Enterprise Manager and Eclipse plug-in. See Enterprise Manager - Database: Types.

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.


See Also

Configuration

Information Tab

Tables Tab

Views Tab

Procedures Tab

Sequences Tab

Permissions & Roles Tabs

SQL Tab

Query Analysis Tab



______________________________________________________________________________________

Copyright BASIS International Ltd. BBj®, Visual PRO/5®, PRO/5®, and BBx® are registered trademarks.